Can Listbox display the values by aggreation expression

[ashok1203]

Hi,

I need to create a list box with the values is 'Y' and 'N'.

If the sum(sales) values is 'Zero' then we need to display the values as 'N' else 'Y'.

This condition will be working to me in charts but not listbox.

Can anyone suggest how we will display the values in the listbox.

[MK_QSL]

I think you have to use as below

=Aggr(IF(SUM({<A,Sales>}Sales)>0,'Y','N'),A)

[ashok1203]

This was working to me.

[ashok1203]

Thanks Manish and other all for your support and help.