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]

Thanks Krishna, i have done the following:

if(Transaction Type='Credit Note',sum(Inv Value))<0,Red()

The Inv Value is a expression, and is a calculation

But it says error in expression??

[PrashantSangle]

Hi,

try

if(Transaction Type='Credit Note' and sum(Inv Value)<0,Red())

Regards

[#4]

Thanks for your patince Carly, sorry still learning this. Okay i now have the following expression, but it returns a blank

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

[#5]

Thanks Max, the expression is okay,

=if([Transaction Type]='Credit Note' and sum([Amount GBP])>0,Red())

but no data??

Thanks for your help

[PrashantSangle]

Hi,

Try like

if(wildmatch([Transaction Type],'Credit Note','Credit Journal'),-Sum([Amount GBP]),Sum(Amount GBP))

or

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

Regards

[#7]

Okay so again diemsnion works okay

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

But field says error in calculated dimension?

[#8 · Accepted solution]

Mhh it seems to work for me.

Ive attached my test doc

[PrashantSangle]

Hi,

Sum(Amount GBP) is a expression you can use it in calculated dimension..

It will give you error

write this as expression

Regards

[#10]

Got it!!

Thanks so much for your help

[krishna20]

Hi Kevin,

I think you have missed if condition.place it correctly and try it with your condition.

Regards

Krishna