Hi!,
I have the same issue, I need to calculate the percentage variation in two values in one new value column.
I have this:
rows Values–> Dic 2017 Ene 2018 % Var Mes
——————————————————————————————————————-
-Row 1 | 1050 2025 ((2025 – 1050)/1050) * 100) = 92%
Row 1.1 | 1000 2000 ((2000 – 1000)/1000) * 100 = 100%
Row 1.1.1 |
Row 1.2 | 50 25 ((25 – 50)/50) * 100) = -50%
-Row 2 |
Row 2.1 |
Row 2.2 |
Row 2.3 |
Row 2…. |
+Row 3 |
+Row 4 |
I need to calculate ( [% Var Mes] = Sum([Ene 2018]) – Sum([Dic 2017]) / Sum([Dic 2017]) ), but the SUM is the SUM of each row aggregated.
I DONT HAVE COLUMNS! ONLY VALUES! –>
columns: [],
values: JSON_DataValues
Sorry for my bad english I hope you understand,Thanks for the help
