AnsweredAssumed Answered

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

Question asked by StephanKrasner_1 on Jan 18, 2015
Latest reply on Jan 18, 2015 by philmodjunk

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.

Outcomes