Forum Discussion
Solved
Problem Statement :- Inventory amount by period Analysis
Hi All Below is the inventory analysis report , i like to add one more probem statment :- Inventory amount by period. Meaning i can know my inventory amount by period. For example :- Peri...
admin11 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.admin11 , if you want based on today, you can create a new column in INVC
Years since = var _1 = DATEDIFF([Last Sales],TODAY(),YEAR) return Switch( True(), _1<= 1, " 0-1 Year", _1<= 2, " 1-2 Year", _1<= 3, " 2-3 Year" , "Other" )
Thank you for wanted to provide the solution. what i want is base on the " Last Sales " field , is the date the items sold to customer. for example if the date first row the date 27 Jan 2018 , mean this items already stock for 3 year ago. what i need to compute all the stock items base on Last Sales date and create the report to show year vs amount report.
admin11 , if you want based on today, you can create a new column in INVC
Years since = var _1 = DATEDIFF([Last Sales],TODAY(),YEAR)
return
Switch( True(),
_1<= 1, " 0-1 Year",
_1<= 2, " 1-2 Year",
_1<= 3, " 2-3 Year" , "Other"
)