topic Re: IF SUM expression not working. How to get it to work? in App Development

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

mwallman — Wed, 26 Sep 2018 15:58:28 GMT

Hi,

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

IF(

Field1='Yes'

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

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 — Wed, 26 Sep 2018 16:16:55 GMT

Hi,

Try this:

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

CarlosAMonroy — Wed, 26 Sep 2018 16:59:29 GMT

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