Forum Discussion
admin11
Memorable Member
Memorable MemberProblem 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...
admin11Memorable Member
Memorable MemberThank 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.
amitchandak
Super User
Super Useradmin11 , 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