Selection Formula for grouping

Options
Hey All, 



At the moment I am tasked with building quite a big report looking at many different piece of information for my organization. We are having an issue when it comes to a formula written to establish records as meeting being scheduled and meeting scheduled. The formula is below. 



if 

    isnull({CnPrProp_1ProLinAct_1.CnPrProp_1ProLinAct_1_IDKEY})

     or not  (

        {CnPrProp_1ProLinAct_1.CnPrProp_1ProLinAct_1_Category}="meeting" and 

        {CnPrProp_1ProLinAct_1.CnPrProp_1ProLinAct_1_Status}= "scheduled" and 

        {CnPrProp_1ProLinAct_1.CnPrProp_1ProLinAct_1_Type}="Dev Solicitation")

             then 1 else 2



So, that is what is puling our report sections into two groups. What we need it to do, but can;t figure out is that if a record has two proposal actions and one is not a meeting it is showing up in both groups on the report. Does anyone have any idea how to stop that duplication?  
Tagged:

Comments

Categories