Displaying different currencies

[khaycock]

I have a weird request, I am trying to get two different currency symbols for the answer to the true and false.

If the site is Ransomes, I want the answer to be displayed in £ and if it isnt, i want the answer to be displayed in $.

IF(Site='Ransomes', IF(AdminFee=1, 35/60*disruption_time+30, 35/60*disruption_time), (99/60*disruption_time)*employeeCount)

Is this possible?

[sunny_talwar · Accepted solution]

May be this:

If(Site='Ransomes',

     Num(If(AdminFee=1, 35/60*disruption_time+30, 35/60*disruption_time), '£#,##0'),      Num((99/60*disruption_time)*employeeCount, '$#,##0'))

[khaycock]

Nope still displays the £ stuff as $

[sunny_talwar]

If this is in a straight table or any other chart, make sure that you have selected 'Expression Default' on the numbers tab of chart properties for this specific expression

[khaycock]

Amazing thank you!!!