Amount display in list box

[#1]

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

[nirav_bhimani]

Hi,

Try this

=if(GetFieldSelections(FieldName) = 'Forecast ',Expression ,0)

Regards,

Nirav Bhimani

[#3]

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?

[nirav_bhimani]

HI,

Please share a demo file.

Regards,

Nirav Bhimani

[kouroshkarimi]

assuming the field you are summing is called 'Value' then you could do something like:

if(isnull(sum(value)),0,sum(value))

[kumarnatarajan]

HI,

Please find the attached file

[#7]

Seems it doesn't work...

Upload a test qvw, I want '0' displayed rather than blank when making some selection.

[#8]

Hi,

I have attached a test file.

[#9]

Hi,

I have updaloaded a test qvw.

[kumarnatarajan]

Hi,

Please find the attachment, it may helps you