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