Skip to main content

I am trying to build a metric to forecast interest income on corporate cash. To do so, I’d like to reference our forecasted cash balance from the balance sheet & cash flow statement. This becomes circular since our interest income rolls into net income which then drives our indirect cash flow statement.

 

I believe I could accomplish it by using the previousbase() function but the various metrics are all across different applications. The interest income & revenue metrics sits in a revenue application that feeds into a nexus in the data hub which then feeds the cash flow statement in a financial reporting application.

 

Does anyone know a way to create this metric given the above criteria?

I think this may be challenging without seeing the exact metrics and calculation but here are some thoughts on how I’ve solved similar issues in the past.
Metric to Metric copy → you could copy Interest Income and Revenue from a “live” metric to a “static” metric so it’s not truly circular anymore.
Repeat calculation → repeat the calculation back to source in various places, so everything sources Cash directly from Cash Flow and the Indirect Cash Flow will not reference Net Income but rather the recalcualtion of Net Income (and rather than adding Interest Income to this it would add Interest Income as Cash * 😵.

Either way - pull all the results into a single application first (Revenue) using Pull metrics (ie. Pull_CashFlow, Pull_Revenue). Having all the pieces in a single application helps. 

I hope this helps get you started. If you have further details you’d like to share let me know.


Hi ​@Shane Crines,
I helped a client with similar issue as your long ago in the past, and I also had the same solution as ​@ClareHutton_QueBIT, confirm it works!

Some extra ideas that might be insightful, of course I put the Metric to Metric import action on the board so client can run it whenever they need to refresh the data,

Plus, I also schedule this import to auto run on a daily basis (as this is the most frequent mode Pigment offer at the moment), so that even when no one runs the actions, we still have latest data for our calculation!
 


Reply