function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Numbers in reports from a picklist

I have a pick list where I have time values in 1/2 hour increments (ie: 1, 1.5, 2, 2.5...).

I need to report totals on this field for reports, I figured i could CASE to convert them into a number field.

Somehow the calculation thinks its 5048 characters long with a max of 5000. Why is it saying the formula is that long...what am I missing?

Assuming I get this formula field to work, can I even do totals in reports based on a number Formula field?

Still searching...

If I make a Formula field with the result being a number (for reporting), I cant get CASE or ISPICKVALUE in the formula to return a number, I get an error saying its type text. Am I missing something to force the result to be a number?

I am in deep dookey if I cant get this picklist value into a field I can sum in a report, soon.

I am officially begging for some HELP on this one.