Skip to main content

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. 

Does this image help you to work it out?

 

If not, maybe if you provide a couple of screenshots of what you are trying to do as it is hard to visualise

Terms & ConditionsCookie settings