Above Function not working properly

[dhanavindhan]

Dear Experts,

I need to take interval  between 2 timestamp fields. One of the field will be considered from previous row value. So, I wrote expression like this,

=aggr(above(interval(BOSPDate - SBEDate,'hh')),BOSPDate)*24

in Output filed "Actual Hour's"  bringing wrong value.

Pls find my attached screenshot it will give better understanding.

For ex:

10/07/2018  13:00:00 - 11/07/2018  15:30:00

Ans : 26:30 Hrs

Output in my Field: 19.00 Hrs

Help me to fix this issue. Why I am getting like this?

Note: BOSPDate is previous row field

Reg,

Dhana R

[YoussefBelloum · Accepted solution]

Hi,

try this;

=interval(SBEDate- above(BOSPDate),'hh'))

[sunny_talwar]

I think Above() is not a problem, but the Aggr() is.... why do you need to use Aggr() here? can you just try this

Above(Interval(BOSPDate - SBEDate, 'hh'))

or this

Above(TOTAL Interval(BOSPDate - SBEDate, 'hh'))

[dhanavindhan]

Hi Youssef,

=aggr(interval(Voyrep.SBE - above(Voyrep.BOSPDate),'hh'),Voyrep.SBE)*24

Only When I use aggr function I get the answer. Actually I dn't knw how to technically explain that.

Tnx for reply.

Reg,

Dhana R

[dhanavindhan]

Hi Sunny,

After Long back, gud to get reply frm u.

Hope ur doing good!!!!

I really don't knw sunny, only when I use aggr function I am getting the answer.

May be the reason it should be aggregated with any one datefield.

[sunny_talwar]

Would you be able to share a sample to show the issue?