I have original values in the database which I want to override using parameters on Dashboard. All the KPI's derived using this override values from parameter contains circular referencing formula or needs output of its own calculation as input for next cycle. Eg:
I get Production and Sales as Input from parameters. And factors as input from database. Rest all existing KPI's in the database should get replaced by new values derived using the new Production and Sales number if any from parameter entries.
Sequence for calculations is carried in the following order: