I have created a formula for calculating the difference of

Question

I have created a formula for the difference of two times , it works fine and returning all rows now i want the sum of all these rows which return the difference of two dates for that i have applied that formula NumberVar TotalSec := Time({zz_tbl_Report_New_Format.MondayOut}) - Time({zz_tbl_Report_New_Format.MondayIn}); NumberVar Hours := Truncate ( TotalSec / 3600); NumberVar Minutes := Truncate (Remainder ( TotalSec,3600) / 60); Totext ( Hours, '####') + ':'+ Totext ( Minutes,'00'); Now I want to calculate the sume how can i achieve that

Mark Tabor · Answer

If i would have tables fields then its not a problem , basically in table i have time saved as varchar for that i wrote a formula to create the difference it works fine and return the difference for two columns right , now i want to sum the result of all these rows see the attachment i want sum to be applied on formula

Sankara Krishnan Venugopal · Answer

Mark, If it is Crystal report, use the formula like SUM(ToNumber({Table.Field))). Find the URL that may help you more, https://www.codeproject.com/Questions/1076143/How-can-I-sum-a-field-in-Crystal-Reports-based-on Thanks.

Mark Tabor · Answer

thanks for response it is crystal report not SSRS and i have above formula which shows difference of two dates so i want to sum at the end of the last rows see the picture =Sum(Fields!MyTotal.Value, "TotalAmount") how i can use that

Sankara Krishnan Venugopal · Answer

HI Mark, It seems you are trying to display the sum of value on SSRS report. If so, you could use the below formula on the column. =Sum(Fields!MyTotal.Value, "TotalAmount") Hope this helps. Thanks!