Suppress row when variables outside range

[mp802377]

Hello,

I have a straight table with several fields and two expressions. The two expressions are for the total duration and total cost. I have 4 sliders. One for the minimum duration, one for maximum duration, one for minimum cost, one for the maximum cost (they really wanted sliders).

Here is the issue. When they change the duration let's say between 9 and 10 hours, instead of the row disappearing that has a total duration of 8 hours, the sum of the duration in the table changes to a 0. I have suppress null values and suppress zero-values checked and that does nothing.

The same issue is with the cost as well. I think it is because they are both in the same straight table but I really need them to be.

Thank you for your help!

Martha

[marcus_sommer · Accepted solution]

I think you need both conditions in both expressions maybe something like:

sum({< Duration = {">=$(vMinDuration)<=$(vMaxDuration)"},

             Costs = {">=$(vMinCosts)<=$(vMaxCosts)"}> Duration)

- Marcus

[mp802377]

Thank you so much! Such an easy fix.