topic Re: Set Analysis where formula equals static number in Search the Community

Set Analysis where formula equals static number

mnev — Thu, 21 Oct 2021 17:42:30 GMT

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])

Re: Set Analysis where formula equals static number

Saravanan_Desingh — Thu, 21 Oct 2021 17:57:51 GMT

Try something like,

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

Re: Set Analysis where formula equals static number

rwunderlich — Thu, 21 Oct 2021 18:01:09 GMT

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

Re: Set Analysis where formula equals static number

mnev — Thu, 21 Oct 2021 18:06:54 GMT

Beautiful solution! Thanks