Forum Discussion
Problem Statement :- Inventory amount by period Analysis
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" )
admin11 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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" )