topic Re: When filtered, bar chart does not round all the bar values in Data Quality

When filtered, bar chart does not round all the bar values

mdubyk — Tue, 25 Mar 2025 15:02:00 GMT

When using a filter (date) on a bar chart I receive a decimal value instead of the rounded number. The formula I am using is: "=round(Num(Sum({<[Type 2]-={'CAP'},[OET Sort]-={'-'}>}[USD Notional- Final])))/1000000" where the bar chart should return the rounded sum of USD Notional - Final where Type 2 does not equal CAP and OET Sort is not blank. However, as the attached screenshot shows, I often receive unrounded values with several decimal places.

Re: When filtered, bar chart does not round all the bar values

Clement15 — Tue, 25 Mar 2025 16:13:23 GMT

Hello,

Try this :

round(Num(Sum({<[Type 2]-={'CAP'},[OET Sort]-={'-'}>}[USD Notional- Final]))/1000000)

Re: When filtered, bar chart does not round all the bar values

mdubyk — Tue, 25 Mar 2025 18:17:03 GMT

Hi Clement,

Thank you for your help! This is definitely better as it removes the decimal error but it seems like the format pattern still does not carry over to all cells unless I refresh the page (see screenshot with highlighted cells showing correct format).

Do you have any insights on why this is?

Re: When filtered, bar chart does not round all the bar values

Clement15 — Wed, 26 Mar 2025 08:12:31 GMT

Hello,
I'm sorry, I don't think I understood correctly regarding the current problem. Can you explain again?

Re: When filtered, bar chart does not round all the bar values

marcus_sommer — Wed, 26 Mar 2025 10:58:05 GMT

num() must be the most outer function of an expression to ensuring the working. Means something like:

Num(round(Sum({<[Type 2]-={'CAP'},[OET Sort]-={'-'}>}[USD Notional- Final])/1000000))

Re: When filtered, bar chart does not round all the bar values

mdubyk — Wed, 26 Mar 2025 21:30:47 GMT

No worries, I figured it out. Thanks for the help!