topic Re: Using Variable in Expression in App Development

Using Variable in Expression

kdstrin1 — Fri, 25 Apr 2025 21:13:34 GMT

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.

Re: Using Variable in Expression

rubenmarin — Sat, 26 Apr 2025 10:50:37 GMT

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)}

Re: Using Variable in Expression

kdstrin1 — Sat, 26 Apr 2025 14:46:33 GMT

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

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download