Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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]))