Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))
or
if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)
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
Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))
or
if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)
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.
Glad to help
Cheers
V