I am trying to calculate a percentage based on the year the user selected to current. I know I am missing something just not sure what.
Thanks
The first line is my current year and the other 2 are suppose to be based on the FISYR the user selects.
(sum({<FISYR = {$(=$(vFisYr) - 0)},[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL] * 1) -
sum({$<FISYR,[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL] * 1)) /
sum({$<FISYR,[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL] * 1)
