Logic to only show range of values needed

Thabang231 — Thu, 09 Mar 2023 12:22:53 GMT

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.

Re: Logic to only show range of values needed

Marijn — Thu, 09 Mar 2023 14:27:02 GMT

Hi,

Something like this?

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

topic Logic to only show range of values needed in App Development

Logic to only show range of values needed

Re: Logic to only show range of values needed