Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Hemachandran1
Contributor
Contributor

Need to place Zero when value is null..

Hi all,

I am doing cumulative  sum in the backend script..

I have more dimensions as in the below image..

I have data in monthwise.. For some dimensions data is not present.. So i need to place zero to do cumulative sum..

For Ex upto Current I need to value. Please help on the same.

Hemachandran1_0-1692457798504.png

Hemachandran1_1-1692457908338.png

 

Labels (1)
1 Reply
Hemachandran1
Contributor
Contributor
Author

I need to get the value upto Max Month.

Ex : Month               Amount

       Jan                      100

       Feb                      10

       Jun                      3

In the above example , Mar - May value is not present.. For that i need to place zero..

Then only i can able to do cumulative sum..

Thanks