Notifications
Clear all
Power Pivot
4
Posts
2
Users
0
Reactions
120
Views
Topic starter
Hi Mynda,
I have applied the formula below to my data model but don't get the same answer - mine is $(115,973) whereas 9.02 is $(1,619,284)
| Returns $:=CALCULATE( [Total Orders $], Returns[Status]="Returned")*-1 |
I have checked the formula so am puzzeled by the big variance. Could you help pleae?
Also there has been a difference in the 'total orders $', but not much, mine is $14,743,167 whereas 9.02 is $14,740,516
Thank you
Posted : 05/01/2018 5:48 pm
Hi Rosemary,
It's impossible to say without seeing your file. Can you please upload it?
Thanks,
Mynda
Posted : 05/01/2018 7:40 pm
Topic starter
Hi Mynda,
I tried but got the following error message.
pp_3_superstore2016.xlsx: Error 106 - Upload file size exceeds maximum allowed size
Posted : 05/01/2018 10:51 pm
Hi Rosemary,
Please email it to me (website@myonlinetraininghub.com), or share via DropBox.
Thanks,
Mynda
Posted : 06/01/2018 7:37 pm
