Setting a dimension value to negative and change color font

[#1]

Hi, i have a dimension called 'Transaction Type' and a expression called 'Inv Value'. in a pivot table.

There are 12 'Transaction Types'. I want the expression values for two specific 'Transaction Types' - 'Credit Note & Credit Journal' to be shown as negative numbers, so a minus in front -123.00, and to be displayed in a red font.

Can anyone help please?

Kind regards

Kevin

[#2]

Sorry last question, how do i turn the font red?

=Sum ([Amount GBP])* if( [Transaction Type] = 'Credit Note' or [Transaction Type] = 'Cdt Journal', -1,1)

[#3]

Sorry forgot to use Visual Cues, all fixed now.

Thanks everyone for your help