Discussions

 View Only
  • 1.  a bucket field to show 0-30, 31-60, etc.?

    Posted 11-12-2020 11:28
    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?

    ------------------------------
    Rick Satenstein
    ------------------------------


  • 2.  RE: a bucket field to show 0-30, 31-60, etc.?

    Posted 11-12-2020 15:37
    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/
    ------------------------------