Hi. I am rather new at this, but I am trying to group the number of days into 3 groups. They will range from 0 to 350. AS you can see, I am working with a formula for the amount of days. I thought this would be so simple, and I appear to be wrong. What have I done?
Here is what I have:
IF {@minimum days} = "0" then "<2", else
{@minimum days} = "1" then "<2", else
{@minimum days} = "2" then "<2", else
{@minimum days} = "3" then "<10", else
{@minimum days} = "4" then "<10", else
{@minimum days} = "5" then "<10", else
{@minimum days} = "6" then"<10", else
{@minimum days} = "7" then "<10", else
{@minimum days} = "8" then "<10", else
{@minimum days} = "9" then "<10", else
{@minimum days} = "10" then "<10", else
"REASON NEEDED"
Thanks for any help you can give me.