Set summary to zero when no selection applied

[Anonymous]

Hi,

I have a chart object that totals the current aged debt of a customer(s) when one (or more) are selected (filtered) but when no customer is selected the total aged debt for all records in the data set is displayed.

Is there a away to  display zero when no customer is selected?

I'll continue to research but if someone knows the answer please tell.

Thanks,
Roger

[Anonymous]

Hi All,

Problem solved.

For those that need to know the following limits the totaling to 1 filter value.

     if (Count(Distinct account_ref) > 1,0, Sum(AGED_CURRENT))

I still think there must be a cleaner solution but can't find it (yet).

Roger

[vinieme12 · Accepted solution]

Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))

or

if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)

[Anonymous]

Hi Vineeth,

Thanks for the response, both work perfectly thank you.

I knew there had to be an existing variable but just couldn't find it.

[vinieme12]

Glad to help

Cheers

V