Skip to Content
0

Account type in member formula

Dec 19, 2017 at 04:23 PM

32

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Dec 20, 2017 at 07:47 AM
0

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!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

You can use "-" in the dimension formula!

0
Vadim Kalinin Dec 19, 2017 at 04:53 PM
0

Stupid answer: why not to check yourself?

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded
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.

0

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

0
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.

0

Please read my answer! This is expected behavior.

0