Friends...
In a Text Box (Text2 ) of my DB report, I’m using the below expression
="Total BDT " & Format$(Sum([Value]),0,0)/1000000 & " Million"
Properties of the text box:
Format : Standard
Decimal Places: 2
Bellow result is being created
Total BDT 25.57775 Million(multi decimal places). But I need the below result
Total BDT 25.58 Million (2 decimal places)
How can I get it?
Would any one suggest me the way, Please…
Rana
In a Text Box (Text2 ) of my DB report, I’m using the below expression
="Total BDT " & Format$(Sum([Value]),0,0)/1000000 & " Million"
Properties of the text box:
Format : Standard
Decimal Places: 2
Bellow result is being created
Total BDT 25.57775 Million(multi decimal places). But I need the below result
Total BDT 25.58 Million (2 decimal places)
How can I get it?
Would any one suggest me the way, Please…
Rana