Remove Zeros in PLD

[Former Member]

Hi All,

Please suggest how to remove the decimals in PLD.

Currently we had configured for 4 decimals, but in the PLD we require only 2 decimals.

Please suggest

Regards

Shanker

[reno1]

Use the option Supress Zeros in the Properties Window, FOrmat Tab.

Regards

Reno

[Former Member]

Hi Supress Zeros will display only 25 if the amount is 25.0000 in your case. You can achieve this by Concat(,) function. Add a text field with 00 value and concat this field with supressed zero field

[Former Member]

Hi,

If you use the Concat function, whenever you have some decimal values (eg 24.68) then instead of the decimals you will see .00 (eg 24.00) so it's not the right solution.

You can use the following formula instead:

Field_XXX*1.00

And tick the Suppress Zeros for Field_XXX at the same time. This will display only the first two decimals properly.

Regards,

Nat

[Former Member]

Hi Nat, I need some clarification for better understanding Consider two cases

25.0000*1.00=?

25.3648*1.00=?

If Supress Zeros are checked Please provide me the out put

[Former Member]

Hi,

You can easily test it, can't you?

The outputs will be:

25.00

25.36

If the suppress zeros is ticked in the original field.

Regards,

Nat

[Former Member]

Hi All,

Thanks for the help. The problem is resolved.

First when i had tried the same by using the option supress zero but it was not working, strange........

Now it is working fine.

Regards

Shanker