Trying to calculate total profit margin percentage

[jmriddic]

I tried this in an unbound text box but it keeps giving me a missing )

=(((Sum([ProdUnitPrice]))-(Sum([ProdUnitCost])))/Sum([ProdUnitPrice])

Basically (total UnitPrice- total Unit cost) /Total Unit Price

 

[vbaInet]

Why don't you start from scratch and add them in one by one. You've got the logic already.

 

[jmriddic]

one by one?

 

[vbaInet]

You've got three Sum() calculations and your logic shows the correct bracketting.

 

[jmriddic]

But I want to calcuate the total profit margin percentage off the totals for each field not one by one. I guess the one by one statement is a little vague

 

[vbaInet]

What I mean is, here's your logic with the correct parentheses:

[B][COLOR=Red]([/COLOR][/B]total UnitPrice [B][COLOR=Blue]-[/COLOR][/B] total Unit cost[B][COLOR=Red]) [/COLOR][COLOR=Blue]/[/COLOR][/B] Total Unit Price

You have three Sum() calculations, e.g. Sum([ProdUnitPrice]). So you simply substitute the values in your logic with the Sum() as I wrote it above. No extra parentheses needed.