Sum Function in Datasheet Subform (1 Viewer)

[sandya]

Hello Friends, Can anyone solve my issue

Sum Function in Unbound text on Datasheet subform

How to make a sum formula without count orange color rows Amount. Because that orange color rows is product return items so no need to count in SubtotalRs. Actually I have used below normal sum formula so it is ok but need to change the formula. I have attached the Screenshot can you please help how to give a formula without count orange Amounts?

=Nz(Sum([Amount]),0)


Thanks,
Sandhya.

 

[Minty]

Presumably there is a returned item flag somewhere that allows you to make the colour change per row?

Assuming there is, something like DSum("LineTotalField", "UnderlyingRecordsQuery", "[ReturnFlag] <> 1")
(this is air code by the way)