Help!!!! Currency Symbol enabled in CRXI

[karnd]

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,

 

[synapsevampire]

You don't say what you want to do, just that you want to handle...If it's just combining the symbolKeep in mind that what you're going to do is build a string.

So try something like a formula of:

if {table.amount} > 0 then
{table.sumbol} & replace(totext({table.amount}),"$","")
else
"(" & {table.sumbol} & replace(totext({table.amount}),"$","") & ")"

-k

 

[karnd]

Hi,

I got it but how should i truncate digits after decimal using the above formula.

like 12345.56 has to shown as 12345
i have tried truncate and round functions but not helped me out.

thanks a lot for your kind help.
regards,

 

[synapsevampire]

if {table.amount} > 0 then
{table.sumbol} & replace(totext(truncate({table.amount},0)),"$","")
else
"(" & {table.sumbol} & replace(totext(truncate({table.amount},0)),"$","") & ")"

Note your original post didn't share this need, in the future try posting example data and expected output rather than a few ambiguous words about what might be done.

-k