Helper IIIHI afonsofeliciano
This is my solution and working like charm 😊
In my scenario user had to enter exchange rate value range between 0.0001 and 999999.9999 and it was very challenging to deal with even given the what if was working perfectly. Coz if you generate a sequence with 1 million rows the pibx file size will go from 5 MB to 1GB which is a efficient at all.
My way you can avoid this bug which rounds off weirdly as well as it won’t increase your pibx file size.
I created four what if parameters. In your situation you might be able to get it done with two parameters.
Then I concatenated those four value measures as a text and then converted to a decimal number. I have put a screenshot below. Let me know if it doesn’t work I will share you with a pibx template.
Thanks,
Deevs