Converting a value to asset or liability - depending on whether it's plus or minus

[abalserv]

Hi Folks
Wondering how to do the following...
I have a balance for a particular company and if the balance of that account is plus, then it's a current asset, otherwise it's a minus.
I was thinking of adding a column to the table that references if it's "reversible" or not. And then if it's reversible...and minus, it's classified as a liability, otherwise an asset...or is there a way to do that via a measure?

 

[tzw1378]

It seems too simple but can't you just use IF(Cell<0,,)...

What else do you need?

 

[jafa1970]

Perhaps you can provide more detail around what you are trying to do, as the explanation is not clear.

I am assuming there is an [Account] column in your data table. Is there rollup columns in the table? ie P&L and BS groupings? If not, you will need these, either in the data table or a lookup (lookup would be a good option as will provide flexibility), but if each account is only on one row, then it does not really matter.

Are you saying there are certain accounts that can be either a Current Asset or a Current Liability (cash at bank comes to mind, however usually these are limited in number, maybe some Tax accounts).

Are you looking to show all values as positive sign (eg both Assets and Liabilities show as positive)? Perhaps you can explain what the output you are after is.

Sorry, lots of questions, but happy to try to help if you can provide more detail.

Cheers

 

[tzw1378]

If I may quickly add to the discussion, is this an accounting discussion or a VBA discussion?

Happy to partake both.

 

[scottsen]

Think I need some sample data to understand, but also a bit of "what you want to do". Sometimes you don't want things in a measure, because you can't put that on a slicer/row/etc. But I didn't really get the "reversible" thing.

I mean...
Liabilities := SUM(Ledger[Values], Ledget[Values] < 0)
might be useful, but ... I dunno the goal

 

[abalserv]

Essentially....there is one account line (this is an accounts thing,not a VBA thing) and depending on whether the balance is a plus or a minus, its categorisation is that of a current asset/liability...think a tax thing. Some years I owe tax i.e. liability, other years (oh happy day!) the tax people owe me i.e. current asset. What I'm doing at the moment is adding an extra field to the chart of accounts table that says if it's "reversible" or not. If the answer is yes and it's a plus, then it's an asset, otherwise a liability. I'm thinking calculated column...but wondering if i could do that as a measure for the balance sheet part...

 

[scottsen]

Depending on if this determination is an aggregate vs on a line level... it might not make sense to do in a calc column. I might need a snip of sample input tables & output pivots to give a "good" answer.

Certainly measures can be written that return strings, if that is the goal:
AvsL := If ([IsReversible], [Value] > 0, "Asset", "Liability")