Skip to Content
0
Jun 21, 2010 at 05:56 AM

Fromula SumGT SumCT in Query Designer

105 Views

Hi Folks,

I have two formulas in the Query Designer.

Formula A with exception aggregation on Material (Count) and didnot use calculate result as Field ( but it is showing some value in the result(count) ) & Formula B with calculate result as total.

Now, Want to calculate the Result of Formula A / Result of Formula B.

Have tried using SUMGT & SUMCT in the Formula.

i.e, SUMCT 'Formula A' / SUMCT 'Formula B'. O/P is showing Zero.

How to achieve this.

Please throw some light in this regard.