Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following dataset:
I display the nb of sales with accumulation per DCP and it works fine:
Starting from that point, I want to display only the DCPs equal or superior to 2 for instance (obviously, in my real case, the limit (2 here) is more complex and is based on a computation taking into account other fields of the table that I don't show here... but let's start "simple" and it is important to notice that I cannot apply a manual filter).
I edited the expression with something like:
Sum({$<DCP = {">= 2"}>} NbSales)
But it still displays all the DCPs, whereas I would expect to not see the DCPs 1 and 0.
Any ideas would be very appreciated 😀
Regards, Fred
Hi,
I've you tried to uncheck Include 0 values the Data handling secion ?
Regards
If you didn't want to show all values and/or limiting them in any way you will need to apply appropriate conditions to your expression, simplified something like this:
if(Condition1, MyExpression1, if(Condition2, MyExpression2, 'myDefault'))
whereby 'myDefault' might be also NULL or ZERO or the (TOTAL) max. Value/Count of any dimension/expression.
Beside applying everything in (nested) if-loops you may also use a wrapping with range-functions like:
rangemin(MyDefault, MyExpression)