Forum Discussion

seanpratt's avatar
seanpratt
Icon for Helper III rankHelper III
6 years ago
Solved

Is this measure possible?

Ignore all the crossed out numbers below. What I'm looking to do for our business is have our Profit and Loss sheet speak directly to our Equity section of the balance sheet. The number on the right (2.369M) is to be plugged in to our retained earnings section (basically account 3000 on the left).

 

Essentially, I want the formula in our left matrix to read as the following logic:

 

IF (Account = 3000, [Add the $ Budget BS and the total of the $ Budget Adj together], [$ Budget BS].

 

Unfortunately I can't share the data due to it being highly confidential and sensitive but hopefully the formula above makes sense? Obviously happy to clarify anything if someone thinks they have dealt with this before. 

 

Need Help

4 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi seanpratt ,

     

    What is the expected output? I failed to understand what you described, are you trying to add rows from another table?

     

    Best Regards,

    Dedmon Dai

    • seanpratt's avatar
      seanpratt
      Icon for Helper III rankHelper III
      6 years ago

      Here's a link to a sample sheet

       

      Dropbox 

       

      I'm basically looking to take the total of one separate sheet and include it only within one account and leave the others alone. This is a simplified version of it, but I should be able to map the logic over to my model.