AnsweredAssumed Answered

Weighted average summary value

Question asked by Kaps_1 on Feb 14, 2015
Latest reply on Feb 14, 2015 by philmodjunk


Weighted average summary value



I have a table called stock with three fields cost exc VAT, price inc VAT and:-

margin = price inc VAT/cost exc VAT

On my layout (based on the table stock) i have a trailing grand summary part, where I need to have three summary fields :-

1) Summary total of cost exc VAT - which I have done

2) Summary total of price inc VAT - which I have done

3) Summary Mark Up - whiich mathematically needs to be  the ratio of the two summary fields. However as you can't use summary fields in calculations, I am stuck. can anybody see how to acheive this ? Thanks