Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to figure out the expression for percentage of month complete. Once I have this figured out I can calculate percentage of monthly forecast compared to spend.
Example
Today() = 4/11/2016
Monthend(Today()) = 4/30/2016
(4/11/2016) / (4/30/2016) = 36.6%
When I do this calculation in Qlikview it is giving me 100%.
Any assistance would be appreciated.
Thanks
If you could share a sample app it would be great
May be try this:
Num(Day(Today())/Day(MonthEnd(Today())), '##.##%')