Calculate Dynamic Value

[PPetronas]

Hi,

I have a field in the report , Response_value which has values such as 1,2,3,4,5 etc depending of the survey_id parameter. I want to calculate a total _repsonse where the formula should be
If Response_value =1 then count(vlues) *1
If Repsonse_value = 2 then count(values)*2
I am not sure who to go about this when my repsonse_values are being dynamically generated?

Thanks in advance,
Petronas

 

[Madawc]

It's not totally clear what you're after. If you want to count double for 2, tripple for 3 etc, then summing Response_value would do it. If it's not numeric, use a Formula Field with ToNumber.

This is based on Crystal 2008. It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[lbass]

I think you should show some sample results and show what the desired result would be. Can't tell whether you are trying to weight results differentially or what.

-LB