Currency Formating

[bnelson111]

Currency Format. I have a straight sum table image below, as you can see the currency is Euro and GBP, I have used if statements to conditional format the values but they don't always correspond is there another way instead of IF? Remember is row changes so standard format wont work?

[its_anandrjs]

Hi,

Try to load currency mapping table with its value.

Thanks & Regards

[MK_QSL]

IF(CurrencyCode = 'GBP', MONEY(YourExpression, '£#,##0.00', '€#,##0.00')

Hope this helps...

[jonathandienst]

Hi

If you are controlling the currency format using Num() or Money() statements in the expression, you need to set the format in Properties | Number to 'Expression Default'.

HTH

Jonathan

[PrashantSangle]

Hi

You can create inline table and link that table with your table

like

currency:

LOAD * Inline

[

Local,val

AUD,1.0908

CAD,1.0187

EUR,0.7399

GBP,0.6650

USD,1.000

];

and create variable as vCur

assign value =val

and in your expression

=Sum(Sales)*vCur

Regards

[#6 · Accepted solution]

Hi

You can use Number to 'Expression Default' and expression like this with any CurrCode and formats:

num(sum(Value),Pick(Match(CurrCode,'EUR','GBR'),'€ # ##0,00;€ -# ##0,00', '£ # ##0,00;£ -# ##0,00'))

[sunilkumarqv]

You can try like these

suggested By John

[bnelson111]

Thanks, brilliant