Divide Payment

[joeKra]

Hi,
i am having a orders Table having customers ordering spots in a publication, so let say that 1 spot is $100 and they ordered 4 spots and they paid only $300 i want a report should show a equal amount for the 4 spots ,in this case $75 for each,
any help will be appreciated !

 

[jdraw]

How about average with total spots/total cost?

 

[CJ_London]

or better still - total costs/total spots

 

[jdraw]

CJ, You don't like number of spots per dollar??? Good catch.