Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Pina
Contributor
Contributor

Compare data with Previous Year Data

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:

Pina_0-1644147268250.png

 Therefore when i divide the value by the previous year, it is 0. 

Could someone help me how we handle this situation?

Labels (7)
1 Reply
Damien_V
Support
Support

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 ?

If the issue is solved please mark the answer with Accept as Solution.