Hi,
I have a picklist field called 'Obesity_class_by_BMI__c' the picklist values are as follows;
- Normal
- Overweight
- Class I obesity
- Class II obesity
- Class III obesity
I have also created separate formula (number) fields for each value shown below;
CASE( Obesity_class_by_BMI__c , "Normal", 1, 0)
CASE( Obesity_class_by_BMI__c , "Overweight", 1, 0)
CASE( Obesity_class_by_BMI__c , "Class I obesity", 1, 0)
CASE( Obesity_class_by_BMI__c , "Class II obesity", 1, 0)
CASE( Obesity_class_by_BMI__c , "Class III obesity", 1, 0)
I also have a field called 'Prevention_Age_Groups__c'
I am trying to create a report that shows the % of patients that are, Overweight, Class I obesity, Class II obesity, Class III obesity.
Please see attached picture of report I currently have below, the totals I am getting are not what I need.
I am sure the formula i created is not right, please see below.
Any help would be greatly appreciated
Matt
Then go with:
CASE(Obesity_class_by_BMI__c,
"Overweight",1,
"Class I obesity", 1,
"Class II obesity",1,
"Class III obesity", 1, 0)=1
As for the report formula, here's how I do it (I don't have the same field/object as you so I went with an Opp report grouped by Type and Stage. My formual is:
RowCount / PARENTGROUPVAL(RowCount, TYPE, COLUMN_GRAND_SUMMARY)
And it is displayed at the Type and Stage levels
