Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.

 

Below is the measure being used 

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

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

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

7 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        ryan_mayu
        Super User
        2 years ago

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