Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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??
Hi,
try
if(Transaction Type='Credit Note' and sum(Inv Value)<0,Red())
Regards
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)
Thanks Max, the expression is okay,
=if([Transaction Type]='Credit Note' and sum([Amount GBP])>0,Red())
but no data??
Thanks for your help
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
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?
Mhh it seems to work for me.
Ive attached my test doc
Hi,
Sum(Amount GBP) is a expression you can use it in calculated dimension..
It will give you error
write this as expression
Regards
Got it!!
Thanks so much for your help
Hi Kevin,
I think you have missed if condition.place it correctly and try it with your condition.
Regards
Krishna