QlikView Forums & Resources
QlikView Creating Analytics
Please enter a title.
You can not post a blank message. Please type your message and try again.
: Dec 5, 2011 8:56 AM by Sagar Hussain
Dec 5, 2011 8:56 AM
I am trying to see if I can get a formula that will add up a cumulative value based on month.
),0)) )),0) ) ),0,
this works fine but if I want to do the same for FiscalYear=2012..
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.
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 >Month(now())+1 (i think this will give January onwards...
Thanks for the help!
This content has been marked as final.
Show 0 replies
Remove from profile
Feature on your profile
More Like This
Retrieving data ...