If statement

[fanninam]

Good Afternoon,

I'm wondering if anyone can help me with this.  I need to include an if statement that says if Month equals 1 then Month equals 13 and Year equals -1.

The reason for this is that headcount is pulled on the first day of the month for the previous month headcount.  For example, January 1st headcount number is the headcount number for December of the previous year.  I already have Month-1 to take care of all the other months.  The tricky part is always going to be January 1st.

[fanninam]

Okay sorry.  I'm still learning several things.  I was able to attach the QVW.  Hopefully this helps.

[juliedecoene]

Hi Amber,

Can you try this?

Text(Date(AddMonths(MakeDate(Year, Month),-1),'MMM'))

[MarcoWedel]

Hi,

another solution might be:

HPU:
LOAD
    DEPT,
    Status,
    EjFTE,
    MonthName(Date#(Month&'/'&Year,'M/YYYY'),-1) as MonthName,
    Month(Date#(Month,'M')) as  Month,
    Year
FROM HCUpload.csv (txt, utf8, embedded labels, delimiter is ',', msq);

hope this helps

regards

Marco