B
bluefalcon904 via AccessMonster.com
Hi...
Im creating a report and one of the field in my report is called JPNet. For
this field, I have the following IIF: JPNet: IIf([Currency]="GBp" Or
[Currency]="TRY" Or [Currency]="ILS" Or [Currency]="ZAR",(TradeMaster.
JPNet/100),IIf([Currency]="BRL",(TradeMaster.JPNet/1000),TradeMaster.JPNet))
However, in my report, it keeps showing 2 decimal places.
Example:
JPNet = 12345.22
Currency = GBp
Since currency is GBP, JPNet should be /100 so JPNet=12.34522 However in my
report it shows 12.34
I tried chaging the properties of the field in the report from
FORMAT = STANDARD
DECIMAL PLACES = AUTO = still shows 2 deci
If I change to to:
FORMAT = "BLANK"
DECIMAL PLACES = AUTO this would show $ sign and still 2 deci
Any thoughts?
Thanks
Im creating a report and one of the field in my report is called JPNet. For
this field, I have the following IIF: JPNet: IIf([Currency]="GBp" Or
[Currency]="TRY" Or [Currency]="ILS" Or [Currency]="ZAR",(TradeMaster.
JPNet/100),IIf([Currency]="BRL",(TradeMaster.JPNet/1000),TradeMaster.JPNet))
However, in my report, it keeps showing 2 decimal places.
Example:
JPNet = 12345.22
Currency = GBp
Since currency is GBP, JPNet should be /100 so JPNet=12.34522 However in my
report it shows 12.34
I tried chaging the properties of the field in the report from
FORMAT = STANDARD
DECIMAL PLACES = AUTO = still shows 2 deci
If I change to to:
FORMAT = "BLANK"
DECIMAL PLACES = AUTO this would show $ sign and still 2 deci
Any thoughts?
Thanks