Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Text Box showing a value calculated by 2 variables. For example var A + var 2.
For Id =100, var A + var B = 35
For Id =200, var A + var B = 20.5
For Id =300, var A + var B = 40.275
For Id =400, var A + var B = 15.25
Requirement:
The result should be rounded up to 2 Decimal places, but only for values/results having 2 or more decimal places. I don't need ZERO after decimals.
For example, my expected output would be
For Id =100, var A + var B = 35 (not 35.00)
For Id =200, var A + var B = 20.5 (not 20.50)
For Id =300, var A + var B = 40.28
For Id =400, var A + var B = 15.25
I tried using NUM( 'var A + var B , '#.##') Can this be achieved in some other ways?
Regards!
Look at these images:
Try like this
It works with variable too.
=if((len(SubField(Number,'.',2))>=1 and len(SubField(Number,'.',2))<=2) or Floor(Number)=Number,Number,
if(len(SubField(Number,'.',2))>2, Round(Number,0.01)))
See the attached
Hi Sunny,
Thanks a lot... This helped.
Regards!
Hi Kush,
Thank you for this useful solution