chart from result of 2 formulas?

[MHPGuy]

I have two formulas that count the number of Males and Females in each contract. I want to have a pie that shows m vs f results (for some reason we don't like numbers- we need pictures).

Is there any way to create a pie from two seperate formula results?


Michael Phipps
Technical Business Analyst
Mercy Health Plans

 

[lbass]

Why do you need formulas for this? You should be able to insert a pie chart in a contract group section that uses {table.gender} as the on change of field, and the count of some recurring field (could be {table.gender}) as the summary field.

-LB

 

[MHPGuy]

Each record in the database has space for up to 6 people, so each record can have multiples of each gender. I figured out how to add up the males vs females, and now I can get the total number, but I don't know how to turn it into a pie.

Michael Phipps
Technical Business Analyst
Mercy Health Plans

 

[lbass]

Please show the content of the formulas you are using.

-LB