Sum Formula field 1

[ruan123]

Yes I've tried your sollution, don't work. CostPrice is only a Price field from the DB divided by a Markup field in the DB. Thank you for the support thus far.

 

[lbass]

You should not have started a new thread. To respond to an existing thread, enter your reply in the box at the bottom of the thread.

If {@costprice} = {table.price}/{table.markup} and{@yourformula} = {@costprice} * .01, then you should be able to right click on {@yourformula}
->insert summary->sum.

I can't think of any reason this would not work. Also, the three formula method would work. When giving feedback, saying something doesn't work doesn't help people figure out what's going on. It is better to say that you got an error message and then specify the exact message and where the cursor was, or to say that there is an incorrect result, and show sample data and sample results.

You need to provide much more information about your report for further assistance, e.g., copy the exact formula into the post, describe your report layout, etc.

Just as a guess, if you have whileprintingrecords at the beginning of your formula, you will not be able to insert a summary on it, so you could remove that (if it is there).

-LB

 

[ruan123]

Thanks for the tips and support, sorry about the way I provided the information of my report, next time I will do it better. My problem was whileprintingrecords at the beginning of one of my formulas. Thanks again.