Skip to Content
0
Former Member
Jun 16, 2009 at 07:24 PM

Query Design - Report Results Problem

26 Views

Hi SDN!

I am having trouble referencing the result value for a metric in Query Designer

Metric = QTY * PRICE

Metric is set to Calculate Result As: Summation

QTY.....PRICE....Metric

5...........10.........50

1...........5...........5

2...........7...........14

Result Row: 8......22.....69 (50514)

The problem occurs when I try to reference the result of Metric using the SUMCT, SUMGT, SUMRT. If I use any of these functions, the value returned is (8 * 22 = 176) which ignores the Calculate Result As.

Metric2 = Result (Metric) * A

Current Result = 176A

Required Result = 69A

Anyone have any ideas how to get the required result?

Much Thanks,

Brendon