'AND' + 'OR' in Set Analysis

[#1]

Hello,

I have an issue:

I need to provide a sum of 'Cost' where 'Type 1' = 1 and 'Field A' or 'Field B' = 1

Something like :

Sum( Type = 'Type 1' and (Field A = 1 OR Field B = 1) Cost )

If anyone could help with Set analysis syntax to perform this, that would be great!

Thanks

BR.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Written from memory (check syntax and parentheses), but something like:

Sum({< Type = {'Type 1'} > * (< [Field A] = {1} > + < [Field B] = {1}>) } Cost )

Hope that helps.

Miguel