Account type in member formula

[Former Member]

Hi all,

What result should I expect when I use a member formula to add an INC and an EXP account together? Let's say I have an income of 100 and an expense of 30.

Or in other words, should the member formula take the amount as it is stored on the database or as it is shown in my report?

Thanks,
Arnold

[former_member186338]

In general dimension member formula is executed after MEASURE formula (where sign conversion happens).

INC(100 on report) + EXP(30 on report)=130

P.S. And the result is not affected by ACCTYPE of the account with dimension member formula!

[former_member186338]

P.P.S. But what's the issue?

You can use "-" in the dimension formula!

[former_member186338]

Stupid answer: why not to check yourself?

For sure I can do this test myself, but...

[Former Member]

I have checked and the result was not what I expected. So maybe I should have asked the question differently. Why does BPC not work as expected?

In my example I would expect the result to be 70 (100 - 30) but I actually get 130.

[former_member186338]

"the result was not what I expected" - but what is the expected result? Please provide ACCTYPE in your sample!

[Former Member]

Let's say I have an income of 100 and an expense of 30

I would have thought this should be enough, but next time I will write it like this

Let's say I have an incomce [ACCTYPE=INC] of 100 and an expense [ACCTYPE=EXP] of 30.

In my example I would expect the result to be 70 (100 - 30) but I actually get 130.

In my example I would expect the result to be 70 [ACCTYPE=INC] (100 [ACCTYPE=INC] - 30 [ACCTYPE=EXP]) but I actually get 130.

[former_member186338]

Please read my answer! This is expected behavior.