hi there
i have three columns in ma source tabel
say TruckQty, AttachmentQty and Class nad SOnum "for group"
first 2 colmn are int type
and calss is string having 2 values only say class1 and class2
now i want sum of att+model for class1 and same for class2
,,,i have used this in a formula field
if {Details.CLASS}="Class 1"
then
Sum ({Details.AttachmentQty}) +Sum({Details.TruckQty})
same for 2nd formula field for class 2
but problem is that on completing the report
it only populate formula field accoring to the last record class
.......mean ma last record has class 1
so it will sum these for class 1 and leaving 2nd formula filed to 0 ,although it has records for class 1 and class 2 both....
so please tell