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
Hi,
Use calculated dimension
Try
Dimension_Name* -1
or
-Dimension_Name
And Click on + symbol
You will get
Font Color Option write
Red()
Regards
Thanks Max, but will that turn the whole dimension negative? I only want certain transaction types in the dimension to be negative and red
Thanks
Multiply the expression by -1 will make your value negative
Then If you want it only to appear in red if it is less than 0 you can add a condition:
Hi,
In calculated dimension you can use If()
like
If(wildmatch(Transaction_type,'A','B'),-ConvertDimension,ConvertDimension)
Regards
Thanks Carly, the only issue i have is that i just want certain transaction types to be negative in the dimension, not all of them
Kind regards
kevin
Dimension_Name* if( [Transaction Types] = 'Credit Note' or [Transaction Types] = 'Credit Journal', -1, 1)
Hi Kevin,
After your expression write <0,Red().
like
if(if(TXN_TYPE='Credit',sum(Invvalue))<0,Red())
Hope it helps.
Regards
Krishna
Thanks, now i get a new field with -1 for Credit Notes, how do i get the 'Inv Value' which is an expression to go negative and red??
Sorry i am not explaining this very well!!
Thanks for your help
kevin
You need to change the expression to this (leave demension as was):
Full_Inv Value_Expression * if( [Transaction Types] = 'Credit Note' or [Transaction Types] = 'Credit Journal', -1, 1)