Picking up opening balance

Hi there

 

I have two modules. Module A has by week time scale and module B has by month time scale. If module B want to pick up opening balance from module A, what formula should I use?

PS, has set up the "The first week?" logic but don't know how to pick up the value from module A.

 

Thank you.

Best Answer

  • prabhu
    Answer ✓

    Hi @AdeleDu,

     

    Change the Summary for the line item in Module A from SUM to Opening Balance.

    Refer directly in Module B.

     

    Capture.JPG

     

     

     

    Capture1.JPG

     

     

    Capture2.JPG

     

     

    Thanks

    Sorna Raja Prabhu