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

[mdubyk]

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. 

[Clement15 · Accepted solution]

Hello,

Try this : 

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

[mdubyk]

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? 

[Clement15]

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

[marcus_sommer · Accepted solution]

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))

[mdubyk]

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