This is the formula called forTotal which shows amount in Dollars.
Another formula called Year is :VB Code:
Sum ({Maintenance_ComplaintDetail.Charges}, {@Year})
VB Code:
Dim strArray() As String strArray = Split(CStr({Maintenance_Complaint.OrderStartDate}),"-") Formula = year(cdate(Left(strArray(3),2) & "/" & strArray(2) & "/" & strArray(1)))
Thanks.




Reply With Quote