You need to sign in to do that
Don't have an account?
ghealy
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?
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?
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.