7 Replies Latest reply: Feb 16, 2012 3:11 PM by Syed Khaled Shahbaaz

# Get Only Two Decimal Values For Output!

Hi,   Consider I'm using the following expression:
=((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100) ... The output is 99.98956896 something
How can I limit the expression to display
values only till two decimal places (like 99.98).
Suggestions appreciated.
Regards,
Shahbaaz.
• ###### Re: Get Only Two Decimal Values For Output!

Hi,

Use this Expression,

Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,0.00)

Thanks & Regards,

Parag Patil

• ###### Get Only Two Decimal Values For Output!

Hi Parag,

Thanks, but that does not seem to work. It shows "No data to display" irrespective of selections made.

I tried experimenting with the number format, but in vain.

Regards,

Khaled,

• ###### Get Only Two Decimal Values For Output!

Hi,

Try this

=Round(sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT)*100, 0.01)

Hope this helps you.

Regards,

Jagan.

• ###### Get Only Two Decimal Values For Output!

Hi Parag,

There are good solutions before my message.

But, perhaps, simply, in the properties, Number-Number Format Settings, Fixed to 2 decimals or Format Pattern #,##0.00

Pierre

• ###### Get Only Two Decimal Values For Output!

You should still be able to use the number format, but do not forget the single quotes. Try the following:

=Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,###.##')

• ###### Get Only Two Decimal Values For Output!

1st way----             You can go in the number tab in the chart and than go to then go to number setting formatting

set the value as--fix to 2 decimal places.

or go to the expression

2nd way---Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,###.##')

or try

Num((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100,'#,##0.00')

regards

Kamal

• ###### Get Only Two Decimal Values For Output!

Hello.

Fixing the number format from the settings didn't work but yes, this expression worked.

=(((sum(HCL_AMT_PAYABLE)/sum(HCL_CLM_AMT))*100) ,0.00)

Thanks everyone..!

Regards,

-Khaled