Hi,
I need a field expression that format a field of a table contains an amount.
stored amount = 10000 ---> should be displayed as =100.00
stored amount = 100 -------> should be displayed as =1.00
last two digits should be showed after decimal.
i had already tried field expression..but cant digging out the exact one.
thanks in advance
fazy... :)
Sivaraman DhamodaranPosted Aug 18, 2014, 7:13 AM
faraz akramPosted Feb 13, 2009, 12:36 AM
hi,
well the datatype of the field is String. anyhow i tried the format code 'N' in the format tab of report field, n its working.
thanks a lot
have a good day :)
Guest UserPosted Feb 12, 2009, 11:04 AM
Change the Value property of the report field to an expression such as:
=YourFieldName / 100.0
Make sure that your query is returning a numeric data type for this field as well.
faraz akramPosted Feb 12, 2009, 12:17 AM
hi .
i set that field property to "d" but its not working
is their anything more i need to do...
an urgent response is highely appreciated.
keep in mind i need the output as 1.00 for 100, 100.00 for 10000
Last two digits should come after decimel.
thanks in advance
Guest UserPosted Feb 11, 2009, 11:25 AM