Hi there,

I am trying to come up with a way of projecting inventory into the future.
This will be based on a number of inputs and outputs but basically the
formula is:

([Current Inventory] +[Inventory In]) - [Inventory Out]

I have two calculated measures that give me [Inventory In] and [Inventory
Out] on any particular day. This works fine.

What I need now is something like the following:

Firstly determine if we are in the future i.e no inventory value so we need
to project it.

IIF(IsEmpty(measures.inventory),
((Time.PrevMember,measures.inventory) + Inventory In) - InventoryOut
, 0) AS [Projected Inventory]

The problem is that this works on the next day after the last current
inventory value but not into the future. I somehow need to base any future
projections on this formula.

I.e

IIF(IsEmpty(measures.inventory),
((Time.PrevMember, measures.[Projected Inventory]) + Inventory In) -
InventoryOut
, 0) AS [Projected Inventory]

I am not sure how to achieve this and combine the logic together.

Any Ideas?

Thanks
Devron

When the recursion terminates, return the inventory:

(Time.PrevMember, measures.[Projected Inventory])
+ [Inventory In] - [InventoryOut],
measures.inventory) AS [Projected Inventory]

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!