Hi,
I have "Amount" field in "money" datatype and "Currency Symbol" field in "varchar" datatype.
Note:The requirement is
1)The amounts are coming in different currencies like '€','$','£' so it has to handle and
2)Negative amounts should be displayed in brackets like (€1000)
so could not able to format it in CRXI using the Format Editor to display multiple currencies.
any ideas should be really appreciated.
Thanks a lot
Regards,
I have "Amount" field in "money" datatype and "Currency Symbol" field in "varchar" datatype.
Note:The requirement is
1)The amounts are coming in different currencies like '€','$','£' so it has to handle and
2)Negative amounts should be displayed in brackets like (€1000)
so could not able to format it in CRXI using the Format Editor to display multiple currencies.
any ideas should be really appreciated.
Thanks a lot
Regards,