Summary Formula by Field Selection

[saltcoats]

Hi all,
I am attempting to do a summary formula that will give a count of field1 if the value in field1 is one of x, y, or z. I cannot group by the field, as I already have my groupings, I cannot do a summary as it does not select just the ones that I want included. I am using CR10.
Any help would be appreciated.

Saltcoats

 

[synapsevampire]

A summary formula of what to display where?

Rather than using text to describe data and output requirements, try providing example data and expected output.

A simple means to perform a summary is to use a Running Total, and in the evaluate->Use a formula place the condition, such as:

{table.field} in ["this", "that", "the other"]

-k

 

[lbass]

Another approach is to create a formula {@xyz}:

if {table.field1} in ["x","y","z"] then 1 else 0

You can then right click on this formula and insert a summary (SUM, not count) to get group totals and or a grand total.

-LB

 

[saltcoats]

Thanks for the help this is just what I wanted.

Gerry