Forum Discussion

DuaneDLB's avatar
DuaneDLB
Advocate II
6 years ago
Solved

What-IF Parameters using decimals

I enjoy using What-If Parameters. The uers like the ability to play the what-if game with their data, however, I am noticing when I need to create a decimal value it will round up to 2 values to the right of the decimal.   When I click inside the What-if filter it will show many position to the right, but as soon as I click oustide of the filter it will round up my value.  I included several screen shots below to help illustrate my question.  Thanks 

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    DuaneDLB set the decimal point to 2 on the column tools on the menu

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

     

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    DuaneDLB set the decimal point to 2 on the column tools on the menu

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

     

    • DuaneDLB's avatar
      DuaneDLB
      Advocate II
      6 years ago

      Thank you for your prompt response but noticed my issue was missing something very important.  I would like for the paramater to default to 3 values to the right. In one of my screen shots I set the selectedvalue '0.345' but when I view my report it still defaults to '0.35'.   

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        DuaneDLB can you make sure the measure also has the 3 decimal points, I tested here and it works:

         

         

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!