Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Forecast 35506
Sales 40000
If I selected Sales it would display
Forecast
Sales 40000
How can I get it to display
Forecast 0
Sales 40000
Hi,
Try this
=if(GetFieldSelections(FieldName) = 'Forecast ',Expression ,0)
Regards,
Nirav Bhimani
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?
HI,
Please share a demo file.
Regards,
Nirav Bhimani
assuming the field you are summing is called 'Value' then you could do something like:
if(isnull(sum(value)),0,sum(value))
HI,
Please find the attached file
Seems it doesn't work...
Upload a test qvw, I want '0' displayed rather than blank when making some selection.
Hi,
I have attached a test file.
Hi,
I have updaloaded a test qvw.
Hi,
Please find the attachment, it may helps you