Iterative Cash Flow Calculation

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Iterative Cash Flow Calculation

    Hi,
    I'm modelling monthly Cash Flows. One Cube for the P/L Statement another one for the Balance Sheet. In excel I solve the dependency (circular reference) between P/L (Interest) and BS (Financing) by iteration (Menu File/Options/Formulas) see the attached file.
    How can I do this with Jedox/Palo (Excel addin)? I'm new to Jedox. Never used the Rule Editor.
    Thanks for your help!
    Ansgar