topic MTD CALCULATIONS, PLEASE HELP in QlikView https://community.qlik.com/t5/QlikView/MTD-CALCULATIONS-PLEASE-HELP/m-p/264102#M1205440 <HTML><HEAD></HEAD><BODY><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Hi,</P><P style="font-weight: bold">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</P><B></B><P style="font-weight: bold">sum</P><B></B><P style="font-weight: bold"></P><P></P>(<B>if</B>(<B>YearToDate</B>(<B>[INVC DATE]</B>,-2,<B>month</B>(<B>today</B>()),(<B>today</B>()-1)),<B>[TOT REG $GP]</B>)) <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 01 Jul 2010 14:25:23 GMT 2010-07-01T14:25:23Z MTD CALCULATIONS, PLEASE HELP https://community.qlik.com/t5/QlikView/MTD-CALCULATIONS-PLEASE-HELP/m-p/264102#M1205440 <HTML><HEAD></HEAD><BODY><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">Hi,</P><P style="font-weight: bold">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</P><B></B><P style="font-weight: bold">sum</P><B></B><P style="font-weight: bold"></P><P></P>(<B>if</B>(<B>YearToDate</B>(<B>[INVC DATE]</B>,-2,<B>month</B>(<B>today</B>()),(<B>today</B>()-1)),<B>[TOT REG $GP]</B>)) <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 01 Jul 2010 14:25:23 GMT https://community.qlik.com/t5/QlikView/MTD-CALCULATIONS-PLEASE-HELP/m-p/264102#M1205440 2010-07-01T14:25:23Z