selection ISSUEs

[mario-sarkis]

hey all i wrote this Expression in to calculate the sum of a balance with these condition , ignoring all selection except   [RM User],[BRANCH] and [RM Full Name]  by putting 1 befor the condition as shown in the below expression , but my prom the expression it still effect with other selection

such as "Month","Year"....., Should i add something to this expression ? Please Help.

=(sum({    1

            <                 [RM User]=$::[RM User]       

                              ,[BRANCH]=$::[BRANCH]       

                              ,[RM Full Name]=$::[RM Full Name]       

                              ,[RM  Party]={1}       

                              ,[RM Product/GL]={'Product'}       

                              ,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}                                   

                      >     

                               }  Balance))

Thank you,

[jonathandienst]

I think this is what you need:

=sum({1<

  RM User]=P([RM User])     

  ,[BRANCH]=P([BRANCH])     

  ,[RM Full Name]=P([RM Full Name])     

  ,[RM  Party]=     

  ,[RM Product/GL]={'Product'}     

  ,Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}                                 

  >}

Balance)

or

=sum({1<

  RM User]=P([RM User])     

  ,[BRANCH]=P([BRANCH])     

  ,[RM Full Name]=P([RM Full Name])     

  ,[RM Product/GL]={'Product'}      

  ,Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}                                 

  >}

Balance)

[jonathandienst]

Another option to try for RM Party is:

,[RM  Party]=P({1} [RM  Party])

[mario-sarkis]

hi jonathan, i need the [RM  Party] to be equal to 1 , thats why i wrote it [RM PArty]={1}

[mario-sarkis]

should i change something in this >>>Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}  ???