I have created a formula for calculating the difference of

Mark Tabor

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mark Tabor8y ago
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 Venugopal8y ago
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 Tabor8y ago
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 Venugopal8y ago
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!