Hello all,

Please help one access greenhorn to get some idea how to do .......

I have a list of metrics which has 1 to 3 inputs. Like x = (A/B)*100, or x = A+B-C or few other formulas.
I have all the inputs stored in one table and each of them has it's own unique ID. Is there a way how to create a query/report where I will have all the metrics listed one by one with calculated results?

Thank you wery much in advance.

Pavel

Sure, in your underlying query, just add columns with the formula. For instance:


select A, B, C, (A/B)*100 as FirstMetric, A+B-C as SecondMetric
from MyTableWithInputsInIt;


There are other ways, this is just the way I'd do it.

Ahoy,

Thank you for your comments.

Regards,

Pavel

NP, glad we could help.