Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try this:
Sum({<Field1={'Yes'}>+<Field2={'Yes'},Field3={'Product*'}>+<Field4={'Yes'}>}Sales)
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