Crystal 10 on Oracle
I am working on a report that uses a separate field for each month (1 - 12). If todays date is in one of the month buckets, I need to grab the value in that bucket and use it in a "quarter" formula. The value in that bucket is the percent complete on a construction job. For instance, if I look at the data today, there is a values of 40% in the month 3 bucket. I need to place this value in a group footer (by project). I know the formula to do this couldn't be that difficult but I just can't visualize the logic - and I'm sure it is because these are montly buckets, not quarterly buckets. In plain english, I want something like,
if todays date is in quarter 2 then grab the value in say, bucket 6 (June - current month). If it is month 6 there is a value in that bucket and the remaining 11 buckets are not populated. When it rolls into month/bucket 7, there is a value in month/bucket 7 and nothing in the remaining 11 buckets and then I need to be reporting on 3rd quarter.
Would it be better to have 4 formulas, one for each quarter or one formula that references all 12 buckets?
Thanks!
I am working on a report that uses a separate field for each month (1 - 12). If todays date is in one of the month buckets, I need to grab the value in that bucket and use it in a "quarter" formula. The value in that bucket is the percent complete on a construction job. For instance, if I look at the data today, there is a values of 40% in the month 3 bucket. I need to place this value in a group footer (by project). I know the formula to do this couldn't be that difficult but I just can't visualize the logic - and I'm sure it is because these are montly buckets, not quarterly buckets. In plain english, I want something like,
if todays date is in quarter 2 then grab the value in say, bucket 6 (June - current month). If it is month 6 there is a value in that bucket and the remaining 11 buckets are not populated. When it rolls into month/bucket 7, there is a value in month/bucket 7 and nothing in the remaining 11 buckets and then I need to be reporting on 3rd quarter.
Would it be better to have 4 formulas, one for each quarter or one formula that references all 12 buckets?
Thanks!