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!

     

     

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

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

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      DuaneDLB That's exactly was my very first reply to check the decimal points on format table. Glad it worked out, may be you required screenshots to understand what I was trying to explain 😀