Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'))
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'))
Nope still displays the £ stuff as $
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
Amazing thank you!!!