nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Aggregation with incorrect data (time difference between report variable and dataset row)

klaucs

<div>Hi all,</div>
I need some help with the folowing:
 
I have a column in a table with a Column Binding made with the expression:
 
seconds = BirtDateTime.diffSecond(vars["VAR_mOFF"],dataSetRow["ORASTART"]); 
minutes = Math.floor(seconds/60); 
seconds = BirtMath.mod(seconds, 60); 
minutesOff = Formatter.format(minutes,"00") + ":" + Formatter.format(seconds,"00");
 
The result are minutes.
When i want to create an Aggregation (sum) from this Column Binding in the table footer, the result is incorrect.
I switch from SUM to Concatenate and the data is not like the one from the Column Binding result (diffrerent numbers)
 
 
I have another Aggregation from a Data Binding without using vars or time calculation and the results are correct.
Exemple: <a data-ipb='nomediaparse' href='http://s23.postimg.org/jwddqokwb/snip.jpg'>http://s23.postimg.org/jwddqokwb/snip.jpg</a> (at concatenate m.OFF are just four numbers because i use some visibility settings)
 
 
Thank you!

Find more posts tagged with

Comments

pricher

Hi,
 
I recognized the example I sent you a few weeks ago... It is weird that when trying to concatenate the MinutesOff computed column, it gives a wrong result. I cannot explain it.
 
Based on the example I already sent, I worked around the issue by concatenating the MinutesOff value in a variable (MinutesOffTotal) that is calculated in the onCreate event of the Detail row of the table, then I display the value of the variable in the table footer with a Text element.
 
The attached example shows that when concatenating the FinishTime fields, it works; when concatenating MinutesOff, it doesn't work.
 
Hope this helps,
 
P.

klaucs

Thank you Pierre,
 
I reproduced your example in my report and is working.
How can i make a sum with those results from MinutesOffTotal?

pricher

Hi,
 
As I said in my previous post, I cannot explain why the concatenation on the MinutesOff value doesn't work.
 
Regards,
 
P.