Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

calculate where does not equal wildcard

I'm trying to calculate the total of "Credit Memo" where Cust_Ref1 is not "JTPD" or where Cust_Ref1 starts with a "W".  Here is what I got but it does not work.  Any advice would be appreciated.  Tha...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    SumValueFilters =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, LEFT ( Table1[Cust_ref1] ) <> "W" && Table1[Cust_ref1] <> "JTPD" )
)
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

 

SumValueFilters =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER ( Table1, LEFT ( Table1[Cust_ref1] ) <> "W" && Table1[Cust_ref1] <> "JTPD" )
)
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thank you for your help!