Skip to Content
avatar image
Former Member

USING MDX in member formula

Hello,

I WANNA calculate Inventory using MDX in member formula. Here is my rule :

I want to calculate final inventory for every month ( final inventory = initial inventory + purchase - sales )

For every month the final inventory is the initial inventory for the next.

I m asking if we can achieve that with member formula or not.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 30, 2017 at 08:48 PM

    Its easier if you put those members in a herarchy, Final Inventory will be the node and set Initial, sales and purchases as child members.

    Add comment
    10|10000 characters needed characters exceeded