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

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

      Anonymous 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        thank you ryan_mayu  the first formula worked