Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Example:
Count(sales) = 100.345625678 (in Text object)
How can i show two decimal points in text object
=Num(Count(sales), '0.00', '.', ' ')
num(count(sales)),'#,##0.00')
try this
=num(Count(sales),'#,##0.00')
Hi
Thanks ....
It's working fine
Thanks
Madhu
Under Textbox text write:
=Num(100.345625678,'#.## ')
or if you want to use any field then mention your field name like
=Num(Field_name,'#.## ')
you are welcome. please mark it as answer if it works.