I have a formula number of days which calculates number of days
I want to write a formula called age and create a group on that in the report.
formula logic
If the number of days >=120
Then display 0 to 120
Else for each next 30 days
display
Previous maximum days +1 to previous maximum days +30
(e.g. 121 to 150 days,151 days to 180 days and ….)
I have a number variable which is
Numbervar Previous maximum days:=120
Can anyone help me to write the code? Is there anyway I can use for loop?
Thanks for the help in advance.
BB
I want to write a formula called age and create a group on that in the report.
formula logic
If the number of days >=120
Then display 0 to 120
Else for each next 30 days
display
Previous maximum days +1 to previous maximum days +30
(e.g. 121 to 150 days,151 days to 180 days and ….)
I have a number variable which is
Numbervar Previous maximum days:=120
Can anyone help me to write the code? Is there anyway I can use for loop?
Thanks for the help in advance.
BB