Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i write a set analysis with the same result and behaviour as sum(if(Field1=Field2,Amount)).
With the set analysis i've tried I always need to select a value in either Field1 or Field2.
As far as I know (at least in 8.5) Set analysis cannot be used the way you want. Set analysis can only be used for one particular value (or more) but with named values.
IN the 9th version I know there is some new things regarding set analysis, but I'm not sure about that.
Yes, V9 extends Set Analysis to allow selection based on another field.
-Rob
Yes, but what i found out i cannot be used as the provided example, only if there is selection within on of the two fields (field1, Field2)
I'm facing the exact same problem. Is there a definitive answer yet?
I was reading a similar discussion here. It gave the following solution to some problem:
SUM( { $ < ShipDate = {">=LaunchDate <$(=DATE(LaunchDate+35,'DD/MM/YYYY'))"} > } Quantity)
which is similar to the topic of this discussion. It was said to work but I have my doubts. The example presented in that discussion had only 1 distinct value for LaunchDate. Adding more rows with different values of LaunchDate broke the expression.