Hello, Folks,
I want to simple divide one field to another but it is giving me wrong answer not sure why. I tried different ways but still problem remain same.
If anyone know pls do let me know.
Sample file is attached.
Thanks
Hello, Folks,
I want to simple divide one field to another but it is giving me wrong answer not sure why. I tried different ways but still problem remain same.
If anyone know pls do let me know.
Sample file is attached.
Thanks
Last edited by AMJADMemon; 06-02-2023 at 01:54 PM.
Cannot manipulate data in a picture. Upload a sample file that is representative of your issue. No more than 8-10 records. Then manually mock up what your solution should look like.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Here is the attached file.
I highlighted in yellow the calculated file and expected answer.
Thanks
Instead of doing your calculated fields in a regular pivot table, load your data to the data model and make your calculations in Power Pivot. It is much more straight forward.
Thanks, I totally formatted about this.
Solved now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks