Round up to 2 decimals, but ONLY to Fractions, NOT to Integers - HOW?

[dmohanty]

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!

[sunny_talwar]

Look at these images:

[Kushal_Chawda]

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

[dmohanty]

Hi Sunny,

Thanks a lot... This helped.

Regards!

[dmohanty]

Hi Kush,

Thank you for this useful solution