RunRate Calculation - Qlik Community

Inessan86 · ‎2019-08-27

Hi,

I'm trying to calculate the run rate, the formula is:

No. of deposits / days from the beginning of the month * days in month

I entered the following expression, but I get an error message:

[FTD#] / (rangemax(1, day(DayStart('$(vYesterday)')))) * Day(Monthend('$(vYesterday)'))

Each of the calculations shows numbers . What can be the issue?

Brett_Bleess · ‎2019-09-05

Inessa, likely going to need sample app etc. on this one in order to help you figure things out.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.