Forum Discussion

aTChris's avatar
aTChris
Resolver I
6 years ago
Solved

Conditional Rounding

Hi everyone   Can anyone think of a way that I can apply conditional rounding to a card? I have a report showing revenue, profit, targets etc for different business units within a group. Some unit...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Use round to in formula and check

    Measure = IF([Measure]>1000000,FORMAT(round([Measure]/1000000,0),"£#.#M"),FORMAT(round([Measure]/1000,0),"£#K"))
aTChris's avatar
aTChris
Resolver I
6 years ago

amitchandak 

 

That is really useful, the only concern I have is the rounding. Using your suggestion I've got it displaying correctly.

Measure = IF([Measure]>1000000,FORMAT([Measure]/1000000,"£#.#M"),FORMAT([Measure]/1000,"£#K"))

However if the value is £309.5K it only shows £309, where I should display £310K

Do you have any suggestions for rounding before I convert to text?

 

Thanks

 

Chris

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Use round to in formula and check

    Measure = IF([Measure]>1000000,FORMAT(round([Measure]/1000000,0),"£#.#M"),FORMAT(round([Measure]/1000,0),"£#K"))