Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am trying to do something like this:
Field:
Category: Product 1, Product 2, Product 3, Product 4, Product 5
Year: 2012, 2013, 2014
What I want to do is this:
If a user selects Product 1 and Year = 2012, then Sum 1 expression
If a user selects Product 2 and Year = 2012 then Sum 2 expression
If a user selects Product 1, Product 2, and Product 3 and Year = 2012 then Sum 1 expression.
Does anyone know how to write an If statement or a check like this?
You can put these conditions as expression's conditon box after clicking on Conditional check box in expression tab of a straight table. Check this sample -