'AND' + 'OR' in Set Analysis

Thu, 14 Jun 2012 13:38:39 GMT

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.

Re: 'AND' + 'OR' in Set Analysis

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 13:48:46 GMT

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