1 Reply Latest reply on Jan 18, 2015 10:14 PM by philmodjunk

    Determine If A Certain Field Contains A Specific Value, Then Writing A Value

    StephanKrasner_1

      Title

      Determine If A Certain Field Contains A Specific Value, Then Writing A Value

      Post

      I made a new field to track members who have made a donation. The purpose of this field is to add a symbol to that person's profile that indicates a donation regardless of their current member status.

      I've tried several different ways to create a calculation for this:

      If ( not IsEmpty ( FilterValues ( Invoice Data::Item ; "CASH Donation" ) ) ; "$" )

      If  ( FilterValues ( Invoice Data::Item ; "CASH Donation" ) ; "$" )

      If (Invoice Data::Item = "CASH Donation") ; "$" )

      None of these seem to work. I'm using the data from a list of found invoices from that member. When I use the Last function, it seems to work:

      If (Last (Invoice Data::Item) = "CASH Donation") ; "$")

      But I don't want it just from the last invoice, I want to evaluate all past invoices from that member.