I created a list box, made a IF expression in General>Field, and made a Sum() expression. If I didn't make any selction, it would display
If I selected Sales it would display
How can I get it to display
=if(GetFieldSelections(FieldName) = 'Forecast ',Expression ,0)
Thank you, but the values in the list box are not fixed, it could also be "Hold", "CB"... Is there any more flexible way on this?
Please share a demo file.
I have attached a test file.
assuming the field you are summing is called 'Value' then you could do something like:
Seems it doesn't work...
Upload a test qvw, I want '0' displayed rather than blank when making some selection.
Please find the attached file
I have updaloaded a test qvw.
Please find the attachment, it may helps you
Retrieving data ...