Forum Discussion
Calculation not working
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. ...
Anonymous
maybe you can try round(max(DEI Threshold),2) or round(sum(DEI Threshold),2)
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.
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
0.8234*1800=1482. You only see 0.82, however, there are still two decimal numbers after 2.