Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm in troubles with the below expression:
=sum(
aggr(
RangeSum(
above(
sum(
if(
Partite_CHIUSE.DataOperazione<%DataRegistrazione, 0, if( [Movimenti Scadenze.DataScadenzaSCA]<%DataRegistrazione, [Movimenti Scadenze.ImportoSCA], 0 ) )
)
, 0, RowNo(TOTAL) ) )
, %DataRegistrazione, %ChiaveScadenzaPagata )
)
in a straight table using %DataRegistrazione as dimension.
I need to compare the two fields Partite_CHIUSE.DataOperazione and [Movimenti Scadenze.DataScadenzaSCA] with %DataRegistrazione of the current row for all above rows.
Is that possible?
Could anybody help me to achieve it? @sunny_talwar @hic @stevedark @Gysbert_Wassenaar @rubenmarin @Thiago_Justen_ @Anil_Babu_Samineni @kaushiknsolanki @marcus_sommer @tresesco
Many Thanks in advance for your time.
Best Regards and Take Care
Andrea
It's much clear now, Do you have any dashboard which demon the issue?