topic Formula Help in QlikView https://community.qlik.com/t5/QlikView/Formula-Help/m-p/279183#M496809 <HTML><HEAD></HEAD><BODY><DIV>Hi</DIV><DIV> </DIV><DIV>I am trying to see if I can get a formula that will add up a cumulative value based on month.</DIV><DIV> </DIV><DIV>eg:-</DIV><DIV> </DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;"><DIV><SPAN style="font-size: 12pt;">RangeSum <SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Above</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Sum</SPAN><SPAN style="font-size: 12pt;">( (</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #800000; font-size: 12pt;">FiscalYear</SPAN><SPAN style="font-size: 12pt;">='2011',(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #800000; font-size: 12pt;">classtype</SPAN><SPAN style="font-size: 12pt;">='Actual',(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #800000; font-size: 12pt;">linetype</SPAN><SPAN style="font-size: 12pt;">='Invoiced',(</SPAN><SPAN style="color: #800000; font-size: 12pt;">val</SPAN><SPAN style="font-size: 12pt;">),0)) )),0) ) ),0,</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">NoOfRows</SPAN><SPAN style="font-size: 12pt;">())) </SPAN></SPAN></DIV></SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV> this works fine but if I want to do the same for FiscalYear=2012..</DIV><DIV> </DIV><DIV>But I want it to add the first two months of our fiscal year (November and December) and then also add the next 10months of sales forecast so that we can see how the year will look. </DIV><DIV> </DIV><DIV> </DIV><DIV>Is there a way for me to tell the above formula to add the Actual Sales and then add the forecast which would be something like &gt;Month(now())+1 (i think this will give January onwards...</DIV><DIV> </DIV><DIV>Thanks for the help! </DIV><DIV> </DIV><DIV>Sagar</DIV></BODY></HTML> Mon, 05 Dec 2011 13:56:07 GMT Anonymous 2011-12-05T13:56:07Z Formula Help https://community.qlik.com/t5/QlikView/Formula-Help/m-p/279183#M496809 <HTML><HEAD></HEAD><BODY><DIV>Hi</DIV><DIV> </DIV><DIV>I am trying to see if I can get a formula that will add up a cumulative value based on month.</DIV><DIV> </DIV><DIV>eg:-</DIV><DIV> </DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;"><DIV><SPAN style="font-size: 12pt;">RangeSum <SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Above</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Sum</SPAN><SPAN style="font-size: 12pt;">( (</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #800000; font-size: 12pt;">FiscalYear</SPAN><SPAN style="font-size: 12pt;">='2011',(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #800000; font-size: 12pt;">classtype</SPAN><SPAN style="font-size: 12pt;">='Actual',(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">if</SPAN><SPAN style="font-size: 12pt;"> (</SPAN><SPAN style="color: #800000; font-size: 12pt;">linetype</SPAN><SPAN style="font-size: 12pt;">='Invoiced',(</SPAN><SPAN style="color: #800000; font-size: 12pt;">val</SPAN><SPAN style="font-size: 12pt;">),0)) )),0) ) ),0,</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">NoOfRows</SPAN><SPAN style="font-size: 12pt;">())) </SPAN></SPAN></DIV></SPAN></DIV><DIV><SPAN style="font-size: 8pt;"> </SPAN></DIV><DIV> this works fine but if I want to do the same for FiscalYear=2012..</DIV><DIV> </DIV><DIV>But I want it to add the first two months of our fiscal year (November and December) and then also add the next 10months of sales forecast so that we can see how the year will look. </DIV><DIV> </DIV><DIV> </DIV><DIV>Is there a way for me to tell the above formula to add the Actual Sales and then add the forecast which would be something like &gt;Month(now())+1 (i think this will give January onwards...</DIV><DIV> </DIV><DIV>Thanks for the help! </DIV><DIV> </DIV><DIV>Sagar</DIV></BODY></HTML> Mon, 05 Dec 2011 13:56:07 GMT https://community.qlik.com/t5/QlikView/Formula-Help/m-p/279183#M496809 Anonymous 2011-12-05T13:56:07Z