Display cost variance with calculated colour presentation

[#1]

Hi all,

I have the following expression in a text box which I want to calculate the difference between the sum of NCOVAC in the current week and week-1 and calculate the positive/negative financial cost (£733/unit)

=(SUM({< Week_Class = {'Current Week'} >} NCOVAC) +

-

(SUM({< Week_Class = {'Week-1'} >} NCOVAC)))*733

This sum is working I.e. if there was 12 NCOVAC week-1 but 8 NCOVAC current week, I get -2932 (4 x 733) but when I adjust the number format settings to Money,I still cannot get the £ symbol.

I'd also like to display any negative cost difference as green and positive cost difference as red but I cannot get the RGB calculated colour settings right.

Thanks for any help.

Matt

[kaushiknsolanki]

Hi,

    Instead of RGB you can use the Green() and Red() functions.

    For example

    if( condition >= 0,Red(),Green())

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik but its still showing only green...

=IF(SUM({< Week_Class = {'Current Week'} >} NCOVAC) -

SUM({< Week_Class = {'Week-1'} >} NCOVAC)*733 >0, Red (255), Green(255))

[kaushiknsolanki]

Hi

    Just give red(), not the Red(255). same for the green

Regards,

Kaushik Solanki

[#5]

Thanks Kaushik, the colour is working now. Any ideas on converting this to

=(SUM({< Week_Class = {'Current Week'} >} NCOVAC) -

(SUM({< Week_Class = {'Week-1'} >} NCOVAC)))*733 to show as £ value in LED textbox?