I have a problem in my query; I need to divide one key figures line value with another key figures report total value, see example below. For instance I need to divide Material As price with the total invoice amount for all materials.
Material Price/Unit InvoiceAmount Weighed index
A..............10..................350.............(10/1000)=0,01
B..............20..................350..............(20/1000)=0,02
C..............30..................300..............(30/1000)=0,03

..................................1000
Any suggestions on how to solve this problem? Im currently using formulas.
Best Regards
/Daniel
You can try the following:
1. Create a new local formula F1 = SUMGT (InvoiceAmount)
2. Create Weighed index = Price / F1
3. You can set F1 properties to Hide
You can indeed do this using formulaes. There is one special formulae to retreive a total for any column and use this. I don't have a system available for the moment. But it should work.
Any other problem?
Tom
Add a comment