Hello,
I am a new user to Qlikview and I am trying to set up so that the data for the current month is phased based on the percentage completed. For example, if I have $100 as the month total, on the 15th day, it will be at $50. I am currently using the formula below, which works when looking at the current month, but if you look at a prior month, it is also phasing that month. I am guessing something could possibly be done with a if statement? Any help would be greatly appreciated.
[code]=((Sum({<Version={Forecasted Sales}>}[Net Sales]))*(Num(Day(Today())/Day(MonthEnd(Today())), '##.##%')))/1000000 [/code]
