Formulas based on Cross Tab Results

[jackchoy]

I'm using a Cross Tab tool to create pass/fail metrics.

True	False
10	5

True	False	Pass/Fail %
10	5	True/(True + False) = 66.66%

However, because there can be cases where there are no True or no False values in the underlying data, the Cross Tab does not always create both columns.  So I sometimes get compilation errors where either the True or False column name is not found by the Formula tool.  Is there a way to always pass the column header so that it will always run successfully?

[Christina_H · Accepted solution]

Set up a text input with True/False columns, no data.  Union to your cross-tab output to force both columns to exist.

Deleting the False column from your data gives this output