Skip to Content
0

USING MDX in member formula

Mar 30, 2017 at 04:59 PM

35

avatar image
Former Member

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.

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

1 Answer

Julio Cesar Castillo Hernandez Mar 30, 2017 at 08:48 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded