decimals formatting

[unknownly]

Hi All,


I have report where I show the the amount based on source field.

So, In source field we have few rate's type then I should be display the amount in 10 decimal format else just the regular amount for other source type.

How can I display amount colum as
1.0000000000
0.0000000450 .. so on when there is a tax rate or exchange rate as a source field.


Any help is greatly appreciated.

Thanks in Advance,

Sweetie

 

[lbass]

Right click on the number field and go to format field->number->customize->decimals->x+2 and enter:

if {table.source} in ["tax rate","exchange rate"] then 10 else 2 //assuming that for other sources you want only 2 decimals

-LB