Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I hope you can help me.
how can i use the red marked field in my expression:
if(red_field>0,sum(value))
(gesamt=total)
Kind Regards,
Lukas
Try TOTAL qualifier with field / dimension list:
=sum(TOTAL<Dimension1> ExpressionValue)
(or specify all the Dimensions you need to consider for your total sum, sum(TOTAL<Dimension1, Dimension2> ExpressionValue) )
But this will only return the total in the same context of Dimension1, i.e. you can't refer the same subtotal for all lines (lines that belong do different Dimension1 values). Do you need something like this?
Lukas,
it looks like you are using four dimensions and one expression, right?
So if you expression looks like
=sum( ExpressionValue)
then try
=sum(TOTAL ExpressionValue)
to retrieve the overall total value (I assume that is your Gesamt value outlined in red).
Then try
= if(sum(TOTAL ExpressionValue) >0, sum( AnotherValue))
Hope this helps,
Stefan
hi Stefan,
i think my example is not so good, here another example.
Its not always the Total value.
I've tried something with dimensionality ( ) = 1 but it also doesn't work.
any ideas?
Try TOTAL qualifier with field / dimension list:
=sum(TOTAL<Dimension1> ExpressionValue)
(or specify all the Dimensions you need to consider for your total sum, sum(TOTAL<Dimension1, Dimension2> ExpressionValue) )
But this will only return the total in the same context of Dimension1, i.e. you can't refer the same subtotal for all lines (lines that belong do different Dimension1 values). Do you need something like this?
thank you 🙂
now it works.