We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hi, i am multiplying the run rate by the working days to give me my target which works fine until i get to the total.
I have used a SUM function to give me my RunRate column which is obviously not correct. What function or formula should i use so that the RunRate total will also equal 10.24 instead of 102.36?
Hi @adam_mac
Try creating a measure rather than a column for the "RunRate = SUM(DailyRunRates[DailyRunRate])" calculation
If this helped resolve your issue please mark my reply as a solution.
Regards,
Veena Shenolikar
hi @amitchandak , the formula i have used for RunRate is RunRate = SUM(DailyRunRates[DailyRunRate]) which i know is incorrect (at grand total level anyway, at individual day level, the 10.24 is correct).
I tried the average function also however this just produces incorrect results.
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
20 | |
14 | |
11 | |
5 |