Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to create a chart that gives me the percentage a value as grown or reduced from the previous year.
I'm trying something like:
Sum({<#snapshot_number = {$(vMaxSelectedSnapshot)}, Year = {2019}} V16130) *100/
Sum({<#snapshot_number = {$(vMaxSelectedSnapshot)}, Year = {2018}>} V16130)
It always gives me 0. I believe the reason is because when i do that data is aggregated like that:
Therefore when i divide the value by the previous year, it is 0.
Could someone help me how we handle this situation?
Hello @Pina
Could that be due because there's a > missing in "..Year = {2019}} " ? I believe it should be "..Year = {2019}>}" ?
Could you also let us know what does the variable vMaxSelectedSnapshot contains ? if this a value or a function ?