I am on IFS Applications 10.
Is it possible to query data from two different tables, without having a JOIN column, in one data source?
I’m trying to calculate a PPM measure for a lobby of statistics to track. I want to take the sum of the quantity in nonconformance report multiplied by one million and then divide by the sum of the quantity of shipped Customer Order Lines. Is this possible? I’ve tried putting all this (with their conditions) in the column of a SQL search but it’s not working.
Could I do this by pulling two data sources into one element and interact them as part of some algebraic function? I haven’t found any functionality like this either.
Any advice would be appreciated.
