Forum Discussion
Wrong Total
Good morning, I am trying to get the Net pay on my bi report but it shows 64500.01 as my total netpay instead of 8826.7, I am not sure why this may be happening...please help. Thank you! ...
sraj - Not quite clear on what you are saying.
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
I am trying to get the Net pay on my bi report but it shows 64500.01 as my total netpay instead of 8826.7, I am not sure why this may be happening...I had mentioned all the examples above so didnt know it wasnt viewable. In your example it has an if statement >1000...I am looking for every value out there.
Thank you!