M
Melanie
I have a query which i run for monthly reports i can get all the data but the
client wants it broken down into different vat groups the one group is 0.14
and one that is set to 0 with the total it works perfectly that all the stuff
balances but he wants to see these two vat rates seperate on sales how would
i formulate a formula that i dont have to build in additional subreports or
change the query but only by a criteria in the sum formula e.g.
=Sum(([SumOfQuantities Sold]*[Unit Price])+([Unit Price]* ([VAT
Rate]=0.14) *[SumOfQuantities Sold])-([SumOfQuantities
Sold]*[Discount])-([Adhoc Discount]))
client wants it broken down into different vat groups the one group is 0.14
and one that is set to 0 with the total it works perfectly that all the stuff
balances but he wants to see these two vat rates seperate on sales how would
i formulate a formula that i dont have to build in additional subreports or
change the query but only by a criteria in the sum formula e.g.
=Sum(([SumOfQuantities Sold]*[Unit Price])+([Unit Price]* ([VAT
Rate]=0.14) *[SumOfQuantities Sold])-([SumOfQuantities
Sold]*[Discount])-([Adhoc Discount]))