IF SUM expression not working. How to get it to work?

[mwallman]

Hi,

I am trying to make the following expression to work in the user interface work:

IF(

Field1='Yes'

or

Field2='Yes' and Field3='Product*'

or

Field4='Yes',

Sum({<SomeSetAnalysisHere>}Sales)

)

It returns a "-".

I have ensured my Sum({<SomeSetAnalysisHere>}Sales) has values,

Most of the 'Yes' fields are Yes/No type fields.

How can I get this to work please?

[jaumecf23]

Hi,

Try this:

Sum({<Field1={'Yes'}>+<Field2={'Yes'},Field3={'Product*'}>+<Field4={'Yes'}>}Sales)

[CarlosAMonroy]

Hi Michael,

Maybe try this:

IF( Field1='Yes' or (Field2='Yes' and wildmatch(Field3,'Product*'))  or Field4='Yes',

Sum({<SomeSetAnalysisHere>}Sales)

  )

Hope that helps,

Carlos M