Calculation not working

[Anonymous]

Hi I'm trying to find a threshold which is calculated as FTE Percentage x DEI Threshold (.82 x 1800). The answer should be 1,476 however, when I put the measure in smartsheet I'm getting 1,482.

Below is the measure being used 

DEI Threshold x AA FTE Percentage =[DEI Threshold] * [AA FTE Percentage] 

[ryan_mayu]

@Anonymous 

how many numbers after decimal point? have you extended the percentage? It looks like 0.82, however maybe you set up only display two numbers after decimal point.

[Anonymous]

@ryan_mayu Hi I'm sorry, I'm a little confused. .8234 is the full number however, I have it set so that it should only be .82. I don't know what you mean by extended percentage 

[ryan_mayu]

0.8234*1800=1482. You only see 0.82, however, there are still two decimal numbers after 2. 

[Anonymous]

@ryan_mayu Is there a way to write a measure that can only show up to two decimal points since using all four is messing up the calculations. 

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try round(max(DEI Threshold),2) or round(sum(DEI Threshold),2)

[Anonymous]

thank you @ryan_mayu  the first formula worked

[ryan_mayu]

you are welcome