Category
Report Builder
Product Version
7.2
Cumulative total - display null
Answered
Hi
I have used the advanced function cumulative total and would like to show null when the actual amount equals 0.
Example
Month amount cumulative
Jan 10 10
Feb 10 20
Mar 0
At the moment I get this...
Month amount cumulative
Jan 10 10
Feb 10 20
Mar 0 20
Is this possible to achieve?
Many thanks
Joe
The same question
Hi Joseph,
Thank you for getting in touch. A toggle option to treat nulls as zeros (or not) has been added to this custom function in the 20170228 build.
Please let me know if you have any questions on this!
Regards,
Nathan
Hi Joseph,
Thank you for getting in touch. A toggle option to treat nulls as zeros (or not) has been added to this custom function in the 20170228 build.
Please let me know if you have any questions on this!
Regards,
Nathan
That's great, thanks very much.
Joe
That's great, thanks very much.
Joe
Hi Joe,
No problem! I am going to close this ticket for now, but if you run into any issues with this, just reply and the case will be re-opened.
Regards,
Nathan
Closed Request Survey
Hi Joe,
No problem! I am going to close this ticket for now, but if you run into any issues with this, just reply and the case will be re-opened.
Regards,
Nathan
Closed Request Survey
Replies have been locked on this page!