Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RafaelPerez
Contributor II
Contributor II

Multiple Restraints on a Set Expression

I'm trying to limit the information shown on a pivot table using the expressions. I want each expression to obey certain conditions. My question is: Do set expressions work like this

=sum({<Condition 1>*<Condition 2>*(<Condition 3.1>+<Condition 3.n>)*(<Condition 4.1>+<Condition 4.n>)} Fieldname)

I want the expression to fall under condition 1 and 2, any condition 3  and any condition 4. 
I've tried this already but something's not working like I thought it would

Thanks in advance

Labels (1)
3 Replies
sunny_talwar

I believe this should work

=Sum({<Condition 1, Condition 2> * (<Condition 3.1>+<Condition 3.n>)*(<Condition 4.1>+<Condition 4.n>)}>} Fieldname)

Made two changes

1) Added Condition 1 and Condition 2 in one set

2) Added a ending >} before the Fieldname 

RafaelPerez
Contributor II
Contributor II
Author

The first point worked fine, I didn't know you could do that. The second addition makes the system go "Error  in expression"

Thanks for the quick reply!

sunny_talwar

Can you share the exact expression you have used?