topic Calculate an Expression off of Available Selections in App Development

Calculate an Expression off of Available Selections

robertsb41 — Sat, 16 Nov 2024 01:53:21 GMT

I have some filters Company & Contract ID. When I select a Company it gives me a list of corresponding Contract ID's and grays out the rest. I want to create a KPI expression that uses the data in the available Contract ID's (not the grayed ones). It currently only uses the data that relates to the selected company.

Is that possible?

Thank you!

Re: Calculate an Expression off of Available Selections

Anismohamed32 — Wed, 15 Jul 2020 18:27:25 GMT

Can you able to explain it better with screenshots or sample app with dummy data

Re: Calculate an Expression off of Available Selections

robertsb41 — Wed, 15 Jul 2020 18:45:08 GMT

When I select a company it gives my the available contract id's as you can see in the pic. My expression works when I select the available contract Id's by themselves and remove the company selection. But I want to make the company selection and have my expression just use the available contract id's.

sum({<[Amount]={"=[Bid Rank] = 2"}>} Amount) - sum(aggr(if(([Bid Rank] = 2),[Direct_Cost_$]),[Amount]))