Forum Discussion
Calculate data values from measures doesn't match
Dear All,
I am trying to create a formula that calculates the cost on a revenue days to late.
To creat this formula I made a few measures:
- Average revenue per day
- Average day's to late
- Total revenue per day to late.
These measures I created:
In my opinion this formula should be correct, but it looks like it calculates diferend value's than the measures show.
I have set the values in cards to show the results
Total revenue per days to late = SUMX('Document Data',[Average revenue per day]*[Average days to late])
Could someone help me with this issue?
Anonymous , I need some data to understand the problem. Can you share sample data and sample output in table format?
Now the product is always correct at line level means
SUm(A*B), NOT Sum(A)*Sum(B)
So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize
Is your result just the product of your first two measures?
Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
4 Replies
Anonymous , I need some data to understand the problem. Can you share sample data and sample output in table format?
Now the product is always correct at line level means
SUm(A*B), NOT Sum(A)*Sum(B)
So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize
Thanks a lot for your reply,
I don't understand the part of SUM(A*B), NOT Sum(A)*Sum(B)
Below I have pasted a part of the data set I use in table format, is this useful?Thanks!
Account DocumentNo C/I Doc. Date Clearing Dun Amount PayT Days Days to late 75149089 66120774 Invoice 10/01/2020 00:00 24/02/2020 00:00 9100 45D 45 0 75174471 66123082 Invoice 14/01/2020 00:00 09/04/2020 00:00 14460 45D 86 41 75174471 66123595 Invoice 15/01/2020 00:00 11/03/2020 00:00 4650 45D 56 11 75174471 66123596 Invoice 15/01/2020 00:00 11/03/2020 00:00 8054 45D 56 11 75174471 66168226 Invoice 16/01/2020 00:00 21/02/2020 00:00 912 45D 36 -9 75174471 66168264 Invoice 16/01/2020 00:00 08/04/2020 00:00 4395 45D 83 38 75174471 66168299 Invoice 16/01/2020 00:00 11/03/2020 00:00 5096.5 45D 55 10 75149089 66128697 Invoice 21/01/2020 00:00 06/03/2020 00:00 67.5 45D 45 0 75149089 66128716 Invoice 21/01/2020 00:00 06/03/2020 00:00 3190 45D 45 0 75149089 66128749 Invoice 21/01/2020 00:00 06/03/2020 00:00 180 45D 45 0 75174471 66129215 Invoice 22/01/2020 00:00 11/03/2020 00:00 3997.5 45D 49 4 75174471 66129216 Invoice 22/01/2020 00:00 11/03/2020 00:00 6467.5 45D 49 4 75174471 66156268 Invoice 24/01/2020 00:00 24/02/2020 00:00 4274 45D 31 -14 75149089 66134708 Invoice 28/01/2020 00:00 13/03/2020 00:00 4765 45D 45 0 75149089 66134712 Invoice 28/01/2020 00:00 13/03/2020 00:00 7885 45D 45 0 75149089 66134737 Invoice 28/01/2020 00:00 13/03/2020 00:00 1700 45D 45 0 75174471 66135116 Invoice 29/01/2020 00:00 11/03/2020 00:00 79095.5 45D 42 -3 75174471 66135117 Invoice 29/01/2020 00:00 11/03/2020 00:00 6565 45D 42 -3 75149089 66143650 Invoice 07/02/2020 00:00 23/03/2020 00:00 14420 45D 45 0 75149089 66148667 Invoice 13/02/2020 00:00 30/03/2020 00:00 4315 45D 46 1 75149089 66155581 Invoice 21/02/2020 00:00 08/04/2020 00:00 3755 45D 47 2 75174471 66160226 Invoice 27/02/2020 00:00 11/03/2020 00:00 912 45D 13 -32 75174471 66160227 Invoice 27/02/2020 00:00 11/03/2020 00:00 255 45D 13 -32 75174471 66189690 Invoice 07/04/2020 00:00 30/04/2020 00:00 32.5 45D 23 -22 75149089 68630611 Invoice 05/06/2020 00:00 20/07/2020 00:00 13440 45D 45 0 75174471 68651872 Invoice 01/07/2020 00:00 31/07/2020 00:00 398 45D 30 -15 75174471 68651873 Invoice 01/07/2020 00:00 31/07/2020 00:00 922 45D 30 -15 75169632 5605127 Invoice 02/01/2020 00:00 14/02/2020 00:00 110.11 45D 43 -2 75169632 5605128 Invoice 02/01/2020 00:00 14/02/2020 00:00 1351.35 45D 43 -2 75169632 5605129 Invoice 02/01/2020 00:00 14/02/2020 00:00 7230.3 45D 43 -2 75160389 5605186 Invoice 02/01/2020 00:00 28/02/2020 00:00 50 30D 57 27 75160389 5605187 Invoice 02/01/2020 00:00 28/02/2020 00:00 383.88 30D 57 27 75160389 5605220 Invoice 02/01/2020 00:00 08/04/2020 00:00 130.4 30D 97 67 75169630 5605654 Invoice 03/01/2020 00:00 18/02/2020 00:00 318.18 45D 46 1 75169630 5605679 Invoice 03/01/2020 00:00 18/02/2020 00:00 818.8 45D 46 1 75169630 5605683 Invoice 03/01/2020 00:00 18/02/2020 00:00 1161.45 45D 46 1 75169630 5605684 Invoice 03/01/2020 00:00 18/02/2020 00:00 1517.78 45D 46 1 75169630 5605686 Invoice 03/01/2020 00:00 18/02/2020 00:00 3791.34 45D 46 1 75169630 5605687 Invoice 03/01/2020 00:00 18/02/2020 00:00 3671.57 45D 46 1 75169630 5605688 Invoice 03/01/2020 00:00 18/02/2020 00:00 8858.22 45D 46 1
Is your result just the product of your first two measures?
Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat,
That worked, so I think thats the same as amitchandak meant with =Sum(A)*Sum(B).Thanks a lot for your support!