Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Inessan86
Contributor II
Contributor II
‎2019-08-27 09:12 AM

RunRate Calculation

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? 

414 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2019-09-05 10:08 AM

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.
383 Views
0 Likes