Using Variable in Expression

[kdstrin1]

Hello,

I am trying to sum volumes using a variable indicating the current fiscal month. The variable is set up as;

LET vMonthNumber=IF(Month(Today())='Apr',7);

My expression that I'm trying to get to work is;

Sum({$<YearDimension={'CurrentYear'},MetricDivision={'Cardiology'},FiscalMonthNBR=vMonthNumber>}[CompletedAppointments.Volume])

I can see the values of Fiscal Month NBR and vMonthNumber in a table and they seem to match (show numerical values), but my table using the expression 0's out the volumes. It seems the FiscalMonthNBR and vMonthNumber don't link to each other. If i change the expression to FiscalMonthNBR={'7'}, it works;

I'm looking for a way to call the variable into the expression so that the current month's values are displayed.

[rubenmarin · Accepted solution]

Hi, If you want to use the month number of 3 months since today, you can use:

LET vMonthNumber=Num(Month(AddMonths(Today(),3)));

And use it as FiscalMonthNBR={$(vMonthNumber)}

[kdstrin1]

={$(vMonthNumber)} was what I needed! Thank you very much!

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download