List subset by formula

Options
yoskaneko
yoskaneko Member, ALL USERS, Partner Posts: 4 Master Anaplanner of the Year
in Planning & Modeling

Dear gurus,

 

I'd like to create inventory report and included "Item master" as dimension.

However, since there is no stock in 50% of item master, it is obviously waste of cells.

So, I'd like to create list or list subset based on "existing stock only".

 

One of idea is to create simple module with item master, and add property as boolean with

formula that "IF Qty > 0 THEN TRUE ELSE FALSE", then import this boolean to

list subset finally.

But, since qty of inventory is monthly basis, but item master does not have time dimension,

I'm not sure how to create formula such as "IF QTY > 0 in Jan or Feb or Mar... THEN TRUE

ELSE FALSE".

 

Yoshi

Tagged:

Categories