Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have KPI descriptions in a list box and their corresponding id's are available in the data.
When user selects multiple KPI descriptions then we need to perform set analysis based on descriptions/or id' selected.
Example: user selects 5,7,9 kpi descriptions then it should convert like Sum( { KPI5 } Values)+Sum( { KPI7 } Values)+Sum( { KPI9} Values)
How to write set analysis dynamically for this scenario.
Might be easy to understand if you are able to share a sample
Sum of Values based on KPI:
sum({$<KPI>}Values)
OR
Sum of IDs, based on KPI_description:
sum({$<KPI_description>}IDs)