Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am creating a table where I would like a column to show a Monthly calculation if a single month is selected. If no month or multiple months are selected, this column should show nulls.
Can anyone help with syntax for something like this? I'm presuming I would add it to the 'Conditional' box for expressions?
Thanks very much.
Mel
Hi,
Try this in your Expression. Hope it helps you.
=if(GetSelectedCount(MonthField)=1,sum(Value), '-')
Regards,
kavita
May be simply a conditional expression like:
Count(Distinct MonthField)=1
Hi,
Yes, you are right.
You can write the general expression for calculation and then Force the Chart to be displayed on the selection of a Distinct Month Value as tresesco has suggested i.e.
Count(Distinct MonthField)=1
Cheers !
Hi,
Try this in your Expression. Hope it helps you.
=if(GetSelectedCount(MonthField)=1,sum(Value), '-')
Regards,
kavita