Skip to Content
avatar image
Former Member

Account type in member formula

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 20, 2017 at 07:47 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2017 at 04:53 PM

    Stupid answer: why not to check yourself?

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

    Add comment
    10|10000 characters needed characters exceeded