Hi.

I have a survey that have calculations in it, when the data is published it shows properly on the report.

But when I generate the customize report shows like this

My formula is correct because is showing 2 digits [*if(selected(${OperatingTimeS},'Non - Operating Time'),(round(int((${TimeOS} - ${TimeSS})div(1000*60))div(60),2)),0)*] in the PDF, but not in the customized report.

Another issue that I'm having is that at the end have a calculation of the repeated input, in this case is the sum of all the "Operationg Hours" and "Non operating hours". The formula is not showing the calculation how it's supposed to.

Formulas

Generate those calculations, see that the "TotalSalt" and "TotalKM" are showing properly but not the first two.

Please if you can help me by telling me what I'm doing wrong.

Thanks.

Hi Angelo,

Does the '0.25' data look correct in the data table?

Looking at the second question, it appears that the sum() function concatenated values instead of adding numbers to gather. Are any of the fields being summed text, note, hidden, or calculate? If so, you need to set the bind:type XLS column to the appropriate data type so that the form will process them correctly.