Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a formula in a Text Object that is calculating certain value and giving a result the formula is
=ReportingCurrency&num(
sum(AGGR([FIN-AP-TA(CuC)], [FIN-AP-ADN],[FIN-AP-ACD],[FIN-AP-CC], [FIN-AP-FY]))
-
sum(AGGR([FIN-AP-TA (CuC)],[FIN-AP-ADN],[FIN-AP-ACD],[FIN-AP-CC], [FIN-AP-FY]))
,' ###0; -###0')
I have tried several different editing the code but no luck . I want comma , at thousand separator this formula returns number like 2434343224 without any comma
I want result like 2,434,343,224 I have tried to change the last bit of formula to ,' #,##0; -#,##0') but getting no luck and result is wrong with this. I did some research on this issue and came across '#'&Chr(39)&'##0','.',Chr(39)) which does not work in this case as well.
Try
num( ..., '#,###.','.',',')
Like
= num( 123456789, '#,###.','.',',')
i.e. specify the decimal and thousand separator and add decimal separator to format code.
Try
num( ..., '#,###.','.',',')
Like
= num( 123456789, '#,###.','.',',')
i.e. specify the decimal and thousand separator and add decimal separator to format code.
Thank You swuehl
Thank you for your answer, which helped me.
Regards,
Vara