Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Comparing Age and to display stocks.

Hi Friends,

I am working on design of a query where it is the Analysis of Title Ageing Process and ther stocks.

I have 2 key figures in my query, Stock Qty and Title Age (in Months).

Stock Qty has been a selection and restricted with variable Cal week

Title Age is a formula Key figure which calculated from Current date variable to Release date.

In my Query I have displayed all each Title against Stock Qty and Title Age.

My requirement is to segregate the Titles stock according to their Age with the following formulae <6Months Old, <12 months, <24 Months, >24 Months, N/A. Under all these columns I have to display stocks.

In Excel by using If condition we can achieve it but as the report is web requirement I need to achieve calculations it in BEx.

In Excel, for e.g.: < 6 months I will write formula as

If(Age>6,0,If(Age<0,0,Stock). Some tomes Title Age is having negative values.

I hope you understand my explanation. For the above each of the columns I need to display the stocks.

I am very grateful to your cooperation in this.

Thanks,

Sudha

Not what you were looking for? View more on this topic or Ask a question