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" )
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"
)