Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi at all,
i have a problem with an intersection in Set Analysis.
I have one Table with Parts, Prices and Factorys.
I need the difference beetween the Prices in two different Factories for the Same Part.
How is the correct Expression with Aggr in a Text Field?
Details in the Example (.qvw)
Hi!
Here is a solution for you:

Diff:
Sum({$<Factory = {'200'}, Part = P({<Factory= {'100'}> }) * P({<Factory= {'200'}>}) >} Price)
-
Sum({$<Factory = {'100'}, Part = P({<Factory= {'100'}> }) * P({<Factory= {'200'}>}) >} Price)
Br,
Miikka Koskinen