Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Looking to create a list box that has four options.
Less than 30 days
Less than 60 days
Less than 90 days
More than 90 days
However everything I have done so far has made 30 day buckets instead. In other words:
0 to 30 days
31 - 60 days
61 - 90 days
90+ days
That wont work for what I need.
What I tried:
=AGGR(
If(WO_Days_Difference >0 and WO_Days_Difference <31, '30 Days or Less',
If(WO_Days_Difference >0 and WO_Days_Difference <61, '60 Days or Less',
If(WO_Days_Difference >0 and WO_Days_Difference <91, '90 Days or Less',
If(WO_Days_Difference >0 and WO_Days_Difference >90, '90 Days or More'))))
, WO_Days_Difference)
I would suggest to solve this in the script: create a field for each bucket to flag if the sales goes in this bucket...then use crosstable to combine the fields in one single field.
PFA the qvw.
I would suggest to solve this in the script: create a field for each bucket to flag if the sales goes in this bucket...then use crosstable to combine the fields in one single field.
PFA the qvw.
That worked great. Would have been nice to been able to do it in an expression, but whatever works!
Thanks for following up Trey- thanks for marking your question as answered which awards points to the members who helped you out.
Best Regards, Sara