Let’s say I have data elements DE1 and DE2. From these data elements I created an indicator Ind where Ind = DE2-DE1. So if DE2 = 4 and DE1 = 4, Ind = 0.
In the data visualizer app, I got the zero value in the Pivot table. But when I select Columns Total to get the sum of all the columns, I got undefined where the value is zero instead of it returning the zero value.
As shown in the attached diagram, I got undefined when the aggregate sum of the column is zero. In the other instance I got the correct value of 1.
Thank you for your post! I can reproduce this issue. It seems like the total is calculated in the app itself (not the API) so it might be a bug in the app. If the zeros are added as text type and not numbers then this probably the reason. Would you like to create a bug issue Projects - Jira?