HEY

[eladzbir]

hey

i want to change this line:

vPreMonthQLIK= MonthStart(AddMonths(Today()-1,-2));

to

if your calander month is january pick december (with numbers), else current month minus 1

thank you

elad

[Vegar · Accepted solution]

Try this

Month(AddMonths(Today(),-1))

Or this if you want to present the number 

Num(Month(AddMonths(Today(),-1)))

[eladzbir]

Thank You

[sidhiq91]

@eladzbir  Please see the code below:

NoConcatenate
Temp:
Load Date,
sales,
Month(Date) as Month;

load date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') as Date,
sales
inline [
Date, sales
01/11/2023,10
04/14/2023,12
07/23/2023,13
08/22/2023,14
12/24/2022,15
];

Let VDec=Month(Yearend(Today(),-1));

Exit Script;

In the front end: for Dimension field use the below expression:

=Aggr(if(GetFieldSelections(Month)='Jan','$(VDec)',Max(Month)-2),Month)

Please let me know if this has resolved the issue.