Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MTD CALCULATIONS, PLEASE HELP

Hi,

I am trying to calculate comparative MTD values for our GP but I have to offset previous years by one day...this is what I have but it doesn't seem to be working like I want....this is for 2008

sum

(if(YearToDate([INVC DATE],-2,month(today()),(today()-1)),[TOT REG $GP]))



0 Replies