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

     

     

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!

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi DuaneDLB 

      I can reproduce your problem.

      Please change the format below and it should work.

      Best Regards
      Maggie
      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • DuaneDLB's avatar
        DuaneDLB
        Advocate II
        6 years ago

        Thank you for your response. I should have checked those settings.  I just started using the 'What-if' parameters and assumed when I set the default values it would automatically format the variable.  It's the little things that put a smile on your face.  Thanks again for your help. 🙂