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
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!
P.P.S. But what's the issue?
You can use "-" in the dimension formula!
Stupid answer: why not to check yourself?
For sure I can do this test myself, but...
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.
"the result was not what I expected" - but what is the expected result? Please provide ACCTYPE in your sample!
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.
Please read my answer! This is expected behavior.