Forum Discussion
Multiply hours by billable rate by change factor
Hi wparker5932
Multiply gets hour*billable rate based on each row context without taking any other condition into consideration. So it does not get the total hour*billable rate as you wanted.
Multipleforonmonth sums the values in “Multiply” column based on the month/year and activity name, thus get the total hour*billable rate as you said.
If my reply help you solve your problem,could you please accept it as a sloved solution?
Best Regards
Maggie
Maggie,
Here is what I am seeing. I created a page that displays the Month/Year from the GDP to USD table, the Month/Year from the Timesheet Table, and multiply, multiplyforonemonth and final result from the Timesheet table.
I then used a filter to display just one month/year (3/2018).
I believe what I should see is that multiply ($16,588.75) and multipleforonemonth ($28,742,322.00) should be equal but they are not.
The final result appears to be applying the correct factor of 1.4082
What does multipleforonemonth do that is a next step after multiply?
If I change to: final result = [mutiply]*RELATED('GBP to USD'[Rate]), I believe I have the correct answer ($23,360) but I would still like to know what multipleforonemonth is intended to calculate.
(Sorry, I have screen captures to share but for the life of me, cannot figure out how to insert them using the icon above)
.
Best regards,
W. Parker
Using multipleforonemonth in final result equationusing Multiply in final result equation