Set Analysis Formula

[tcyw2910]

Hi,

I was wondering what the set analysis formula structure is, if I wanted to have two conditions, where one is accepted, but the second isn't.

I.E. I want data to be pulled specifically for the first condition, but not the second. 

Thanks,

Terence

[Chanty4u · Accepted solution]

Not sure with your question but my assumption

Yourfield

Test1

Test2

now test1 is accepted and test2 is not accepted

sum({<Field={'Test1'}>}amount)

or

sum({<Field={'Test1'},Field1-={'Test2'}>}amount)

if not share sample data and output also.

[tcyw2910]

Apologies, I wasn't clear but that second one was what I was looking for!

Thank you, appreciate it 🙂