Is this measure possible?

[seanpratt]

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. 

[v-deddai1-msft]

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]

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.

[seanpratt · Accepted solution]

bump?

[v-deddai1-msft]

Hi @seanpratt ,

What's your expected output based on your sample data?  I still don't understand your logic for it.

Best Regards,

Dedmon Dai