Hi All,
I've read various things on this but I can't get it quite right.
We're building a KPI document for finance and rather than editing the app each time, we would like them to be able to define the kpis in a spreadsheet, along with the calculation.
I can get this part working fine using a pick/match, however I would like to dynamically build this pick/match formula so if they add any additional kpi's they are automatically added.
This is the little bit I can't quite fathom out.
I've attached a simplified version of what I am attempting.....
Kind regards
Adam
