Limiting a dataset with a variable input

Evan0211 — Mon, 15 Nov 2021 16:33:07 GMT

I have a table that is like this....

Base Fee	Incentive Fee
100	-
-	100
500	-
400	-
-	300

etc.

I have created a variable input with three buttons: Show All, Base Fee, Incentive Fee

I am working on the functionality to limit the data now, but I cannot programmatically filter out the nulls for some reason.

I have tried:

=if(Not isnull(len(trim(BASE_FEE))),BASE_FEE)

=if(not isnull(BASE_FEE), BASE_FEE)

=if(LEN(Trim(BASE_FEE)) > 0, BASE_FEE)

UPDATE: I have added this expression, which will make the null (-) a 0, but I am still unable to filter out the rows where BASE_FEE = 0

=if(Aggr(Alt([BASE_FEE],'0'),BASE_FEE) > 0, BASE_FEE)

I can find the BASE_FEE that is not null, but I cannot filter out the BASE_FEE that is null (which shows in the table as -). I will wire all of the functionality into a variable once it is working, but for now I am just trying to hardcode to test.

Any ideas?

Re: Limiting a dataset with a variable input

edwin — Mon, 15 Nov 2021 20:28:12 GMT

if BASEFEE is a dim, you can set the ignore null. if you are are using it as a measure, try if using the modifier BASE_FEE={"*"} will help

Re: Limiting a dataset with a variable input

edwin — Mon, 15 Nov 2021 20:28:54 GMT

BASE_FEE={"*"} will exclude rows with null BASE FEE in your calculation

topic Re: Limiting a dataset with a variable input in App Development

Limiting a dataset with a variable input

Re: Limiting a dataset with a variable input

Re: Limiting a dataset with a variable input