Adding color to a calc field

[Angus Murray]

I have a Calculation field ('Final_Total') which currently adds up an Invoice Total + gov. tax. This in itself works great. I would like to add to this field the ability to turn the data red if over 30 days after the invoice date.

I think somewhere in here my syntax is wrong or I have missed something obvious. I am very new to the wonderful world of calculations.

My current calculation is as follows:

Invoice_Total + Tax_on_total

and

Case (IsEmpty (Invoices::Date_received ) & Invoices::Invoice_Date < (Get ( CurrentDate )-30);

TextColor (Invoices::Final_Total ; RGB ( 255 ; 0 ; 0));

TextColorRemove (Invoices::Final_Total))

Thanks in advance for any help with this....and for invaluable help with my previous posts on the forum.

[Asda]

Try using "not" before the IsEmpty function.

i.e.

not IsEmpty(...

[Angus Murray]

I want the field 'date received' to return 'empty' since this field defines whether the invoice has been settled or not, and is only filled once payment has been made. I am seeking to find unpaid invoices and turn those over 30 days red.

Thanks for your reply.

[comment]

You are using a text operator & where the logical operator and is required.

[Angus Murray]

Many thanks - works as hoped for.