The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am wondering why my subtotal is not rounding as expected. I expect to see $26,680.37 but was getting $26,680.35 as shown below. Kindly help
In most cases, the subtotal will show the sum of the actual underlying numbers, rounded to a certain number of decimal places, rather than the sum of the displayed numbers, which may be rounded.
If you expect your rounded subtotals to always be the sum of the rounded components then you are not going to have a good time in general since the requirement leads to showing inaccurate totals or inaccurate components.
@cosmasadesegha, Are you trying to add two decimal places, that is not correct. Please increase decimal place(Say 5) and check the total again
Hi @cosmasadesegha ,
Please change the decimal places for Burdened Amount to 0. This will also round up the measure values and at last, subtotal will also give round-off value.
Thanks for your prompt response. If I change the decimal places to 0, I will get a whole number value and that is not what I want to get. I want it in two decimal places but having the subtotal rouding up and not down.