Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try this;
=interval(SBEDate- above(BOSPDate),'hh'))
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'))
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
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.
Would you be able to share a sample to show the issue?