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.
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
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'))
Above(TOTAL Interval(BOSPDate - SBEDate, 'hh'))
=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.
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.