Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello how can I make my set analysis work coz I'm getting an error? I have this sample below
Sum( Qty * [Price])
Price is also computed using set analysis.
Thanks!
You mean Price isn't a field else an expression with an included set analysis which also means that it's based on an aggregation-function? In this case it would mean that you are nesting aggregations without using an aggr() because Price doesn't return the expression-result else it's just a reference to the expression behind it.
Did you try it in this way: Sum((Qty) * [Price]
- Marcus
You mean Price isn't a field else an expression with an included set analysis which also means that it's based on an aggregation-function? In this case it would mean that you are nesting aggregations without using an aggr() because Price doesn't return the expression-result else it's just a reference to the expression behind it.
Did you try it in this way: Sum((Qty) * [Price]
- Marcus