Forum Discussion
How to create Age bins
I want to replicate the following table and am looking for the formula to achieve so. I have a Quotes with data that is as the following. Quote ID Client Name Quote Date 1...
Anonymous , You can create a column like
New column =
var _day = datediff([Date], Today(), day)
return
Switch( True(),
_day <=30 , " 0- 30",
_day <=60 , " 31- 60",
_day <=90 , " 61- 90",
"> 90 ")
amitchandak
Super User
Super UserAnonymous , You can create a column like
New column =
var _day = datediff([Date], Today(), day)
return
Switch( True(),
_day <=30 , " 0- 30",
_day <=60 , " 31- 60",
_day <=90 , " 61- 90",
"> 90 ")