Sum fields with condition
Sum fields with condition
(OP)
I am trying to SUM totalsale by certain vendor by creating a formula call @CertainVendorsTotal
below is my syntax and I appreciate if someone can help me. Thanks.
Sum({sp_rpt_Vendor;1.InvTotal}, ({@CertainVendorsTotal} in "HHH",KKK","GGG"))
sp_rpt_Vendor is a store procedures name
below is my syntax and I appreciate if someone can help me. Thanks.
Sum({sp_rpt_Vendor;1.InvTotal}, ({@CertainVendorsTotal} in "HHH",KKK","GGG"))
sp_rpt_Vendor is a store procedures name
RE: Sum fields with condition
{table.field} in "HHH",KKK","GGG"}
-k
RE: Sum fields with condition
{table.vendor} in ["HHH",KKK","GGG"]
You might also be able to create a formula for the detail section like:
if {table.vendor} in ["HHH",KKK","GGG"] then {table.amount}
Then insert a summary on the formula at the group level.
-LB