Hello,
I have a relationnal model,
I have a calculation for turnover from one part, fees and clients from an other part
If I create a query in query studio with only fees and turnover, lines are in front of each other the query is correct.
when I add clients to the query in query studio lines of turnover and fees are duplicated with alternating null value like a chess board (instead of being in front of each other without null values)
I've checked that elements in framework manager can be summable.
fees and turnover are linked to exactly the same ids in relations (let's say id1 id2 id3 id4)
but for clients, some ids can not be linked to it (id3 and id4)
As ids are not in the same table it is not possible to define determinants
If information is missing a sum should be applied.
How to make all elements appearing on one line with correct values
Thanks very much in advance
ps: sorry for my approximative english