Calculating Percent of Month Complete

[#1]

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

[satishkurra]

If you could share a sample app it would be great

[sunny_talwar · Accepted solution]

May be try this:

Num(Day(Today())/Day(MonthEnd(Today())), '##.##%')