I have declared variable as part of my script. It assigns value based upon month.
So, if Current_month = 'April' , variable will be "vMonth1_Revenue'. (Field has revenue for month of April). It loads fine.
Now, I want to do summation on "vmonth1_Revenue". The problem is column show up as "April_Revenue". I am going to refresh the report every month so I want to refer variable instead of actual column name.
I tried following variety of expression, all of them either gave me "Missing ( - ) " or " Zero ( 0 )" or nothing as output.
=sum('$(vRotate_month1)' & 'Revenue_' )
One suggestion was to create another variable: vTEST= vRotate_month1&'_Revenue' and do =sum(vTEST).
It works, but I have 20 variable to sum upon. I don't want to create 20 temproary variables. I am sure there is easy way.