Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I need to calculate the increase/decrease every year compared to 2012.
The field expression I am using is: Sum("Passenger Count") - Sum({<[Year]={'2012'} >}"Passenger Count")
The result only correctly calculates 2012: 69-69=0. The other years show actual Passenger count, not the increase/decrease. Where am I going wrong with this?
Try this
Sum("Passenger Count") - Sum(TOTAL {<[Year]={'2012'} >}"Passenger Count")
Try this
Sum("Passenger Count") - Sum(TOTAL {<[Year]={'2012'} >}"Passenger Count")