a bucket field to show 0-30, 31-60, etc.?
I have a report which shows Days Aging and I'd like to create a bucket field to show 0-30, 31-60, etc. etc. Does this require a formula field, and if so, can anyone point me in the right direction?...
Forum Discussion
Yes. You'll probably want a Formula Text field and it would need to be something like:
var number aging = [Days Aging];
IF($aging>0 and $aging<=30,"0-30",
$aging>30 and $aging<=60,"31-60",etc...)
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
var number aging = [Days Aging];
IF($aging>0 and $aging<=30,"0-30",
$aging>30 and $aging<=60,"31-60",etc...)
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
