Logic to only show range of values needed

[Thabang231]

Hi Team 

I would like an assistance, i wanna build a logic to only show a range of values from 30 to 60 inclusive, and this logic i would like to build in KPI, in the table and also put it in the bar graphs. So even when i pull the bar graph it show only show me the books ranging from 30 to 60 only and exclude the rest, how to build this. 

and currently here is the formula i have that shows the value and i need to do the range on it, so with this formula i want it to only show me outputs which range on 30 to 60 only and it should ignore the rest :

The expression is:

(sum(TripFuel)/sum(TripDistance))*100

Your help will be highly appreciated.

[Marijn]

Hi,

Something like this?

if( (sum(TripFuel)/sum(TripDistance))*100 >=30 
        and (sum(TripFuel)/sum(TripDistance))*100 < 60,
(sum(TripFuel)/sum(TripDistance))*100 )