Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Excuse me for the title of the post, but I don't know how to summarize my problem.
Basically, I have a table such this one:
Order | ValueA | ValueB |
---|---|---|
1 | 10 | 13 |
2 | 12 | 12 |
3 | 15 | 10 |
4 | 19 | 18 |
5 | 11 | 16 |
Where ValueA and ValueB are calculated values (using expressions).
I need to make the following computations:
In conclusion, I need to create two Text fields, one containing the value 8 and one with 6.
Is it possible?
No problem.
Ok try this:
First B>A:
sum(Aggr( if( (if(IsNull(DataOraInizioPrecoordinamento),sum(if(DataOraMinuto>= DataOraInizioPrecoordinamento and DataOraMinuto<= DataOraFinePrecoordinamento, QtaPrecoordinamento)),0))>(sum(if(DataOraMinuto>= DataOraEntrataTimbraturaSettore and DataOraMinuto<= DataOraUscitaTimbraturaSettore, 1))),(if(IsNull(DataOraInizioPrecoordinamento),sum(if(DataOraMinuto>= DataOraInizioPrecoordinamento and DataOraMinuto<= DataOraFinePrecoordinamento, QtaPrecoordinamento)),0))-(sum(if(DataOraMinuto>= DataOraEntrataTimbraturaSettore and DataOraMinuto<= DataOraUscitaTimbraturaSettore, 1))),0),DataOraMinuto))
Second A>B:
sum(Aggr((sum(if(DataOraMinuto>= DataOraEntrataTimbraturaSettore and DataOraMinuto<= DataOraUscitaTimbraturaSettore, 1)))>
if((if(IsNull(DataOraInizioPrecoordinamento)
,sum(if(DataOraMinuto>= DataOraInizioPrecoordinamento and DataOraMinuto<= DataOraFinePrecoordinamento, QtaPrecoordinamento))
,0)),(sum(if(DataOraMinuto>= DataOraEntrataTimbraturaSettore and DataOraMinuto<= DataOraUscitaTimbraturaSettore, 1))) -
(if(IsNull(DataOraInizioPrecoordinamento)
,sum(if(DataOraMinuto>= DataOraInizioPrecoordinamento and DataOraMinuto<= DataOraFinePrecoordinamento, QtaPrecoordinamento))
,0)),0),DataOraMinuto))
i think you can just use if (column(1)>=column(2),column(1)-column(2), column(2)-column(1))
see attached
Thank you for the answer but, as I told in my first post, I need to show these values inside two Text fields, not in the table.
Hi,
what about using relative Columns
sum(if(Column(2)>Column(1),Column(2)-Column(1),0))+
sum(if(Column(1)>Column(2),Column(1)-Column(2),0))
Greetings from Munich
Martina
Thank you very much, it works!