Set Analysis where formula equals static number

[mnev]

Hi all, I am trying to create a formula with set analysis where it checks if a function is equal to a value. However, it is not working. My goal is as follows: IF Sum(Right([Field], 7)) equals zero then return value. Is there an issue with my syntax? Much appreciated.

=sum({<'0'={'$(=Sum(Right([Field], 7)))'}> } [Value])

[Saravanan_Desingh]

Try something like,

=Sum({<[Value]={"=Sum(Right([Field], 7))=0"}>} [Value])

[rwunderlich · Accepted solution]

The left side of a modifier must be a fieldname. In your case, you will need use another field like an ID to select the rows and the formula as a filter. Like:

=sum({<ID = {"=Sum(Right([Field], 7)) = 0"}>} [Value])

Mind the double quotes around the formula. 

-Rob

[mnev]

Beautiful solution! Thanks