Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created a straight table with two dimensions and 5 expressions
The dimensions are the customer name and code. The expressions work sales value etc.
My last expressions works out the difference between the exposure and the credit limit.
Some customers have obviously gone over their credit limit and show a negative value in this expression.
I need to exclude any rows that have a positive value in the final expression, basically include any customers that have gone over their credit limit. I know it is easy enough to exclude columns but not so easy with rows.
Any help would be greatly appreciated. Thanks in advance
Dave
Would you be able to share your app with us?
how do I do that?
company policy won't let me send it even if we use the scrambler...
Hi!
Have you tried with dimension (see below)
Not sure what else to do... May be provide some dummy data in its raw form and explain what you want to see?
if you only want to show negative values derived from your expression then do the below
if you want to show positive values just invert to ">" greater sign.
1) Expression
=IF( YourExpression < 0 , YourExpression)
2) On the Presentation tab check Suppress missing values
I can't get it to work. I don't think I can reference an expression in a dimension
unfortunately this doesn't seem to work
my expression is =if([Leeway]<0,[Leeway])
I have checked the Suppress Zero-Values and Suppress Missing and all the 0s still apppear
Leeway truely zero? Or is it something like 0.0000001 (a number greater than 0, but smaller than 1)? May be try this
=if(Round([Leeway]) < 0, [Leeway])
or
=if([Leeway] < 1, [Leeway])