Comparing Age and to display stocks.
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.