Hey Tonya, like Mark mentioned we can't always control the colors that will be used, but you can control the results of your formula to force otherwise unrelated values into common groups. The groups may then be included as the Series in Pie Charts.

I don't think your formula logic as it stands will yield the expected result as there are multiple conditions that are unclear. For example, if we take the just the first condition, what are you hoping to evaluate and what should be the outcome if true? To me it seems like you blended the logic of a couple different scenarios and they may be better are two different formulas, for example one formula outputting the "age" and other "outputting" the type?

Then, you would take the results of that formula and set it as your Series. Quickbase will then auto-color each Series group (pie slice). If you go back into the report settings, you can manually override the colors by clicking the little color swatches in the Legend.

Oh, regarding your error … it's because there is a mismatch between what you have set as your Field Type (Boolean) and the results of your formula which is presumably outputting text (e.g. "HIPO" or "#2ca01c").

Hopefully that helps!

------------------------------

Brian Seymour

------------------------------