Hello,

1. =Yes
2. =No

I would need two seperate formulas.  I have tried the shared variable formulas but it is counting the data that I am supressing. For example, the chart screened will have three lines as will the trial available, but the max will only display the overall "Yes", thus this would count as one record. How do I get the correct count?

hi

When you are counting 'Yes' you need to consider your suppress condition also. ie. based on your suppress condition you have to count your 'Yes'

Example : your suppress conditon is some thing like :

If value > 5000 then true else false

YOur count conditon should be like :

if value < 5000 then count else 0

--if this is not going to solve your problem, post your query in detailed with a data example.

create a formual to concantenate the name and date field.