Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Contributor III
Contributor III

Straight Table - using expression to filter unwanted rows

Project Name Task Value1 Value2 Value3
P1 T1 10 2 8
P2 T1 9 11 -2
P3 T3 0 6 -6

 

 

I'm looking for a way to limit the data returned in the table above - I only want to return rows where Value3 is less than 0. I know this should be easy but I just can't think of it today!

Labels (3)
7 Replies
MatheusC
Specialist
Specialist

Hi, @orangebloss 

you can define restrictions based on your dimension and the calculation of Value3

as an example of the print below:

MatheusC_0-1706712687746.png

and then in the dimension limitation select values ​​>0

MatheusC_1-1706712711084.png

 

MatheusC_2-1706712738677.png

Regarts,
Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
anat
Master
Master

if(sum(value3)<0,sum(value3))

Chanty4u
MVP
MVP

Try this

=if(Value3 < 0, Value3, null())

 

orangebloss
Contributor III
Contributor III
Author

Hi - thanks for this - does it automatically filter on the first sum value? or if any of the numbers are negative?

 

Just trying to understand how this works!

orangebloss
Contributor III
Contributor III
Author

Hi Anat, I can't apply this to the dimension? it says invalid dimension? If I use this in the field it just calculates value 3?

MatheusC
Specialist
Specialist

@orangebloss 

It will filter according to what you put in the limitation


extract value
>0

-> if you enter the value 0 in the expression in the limitation part then in this case it will eliminate the negatives and 0 based on the Value3 measure and to do this, you need to enter it as your first measurement, as was the case with the first print sent.

Regarts,
Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
MatheusC
Specialist
Specialist

Did you get the solution?

Close the topic with the solution met and leave a like if you found it useful.

Thank you!

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!