Fromula SumGT SumCT in Query Designer

[Former Member]

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.

[former_member181964 · Accepted solution]

Hi,

See the Properties... in Formula Collision

Whenever you define two structures that both contain formulas, it is unclear to the system how to calculate the formulas at the point where both formulas intersect.

See the below URL in SAP help...

http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/71/0aec3b6e011341e10000000a114084/content.htm

Thanks

Reddy

[Former Member · Accepted solution]

Problem not solved,

What will be the overall result of a formula by default ?

[Former Member]

Hi,

Simply create a formula A/B, and display no further settings are required.

But ya make sure that Formula A and Formula B are in the same structure.

- Jaimin

[Former Member]

Both the Formula' exist in the same stucture and have done no changes to the settings in the third formula.

Its not working.

[rathy_moorthy2]

try giving in the new formula as ormula A / formula B and in properties of this new fromula give calculated result as nothign defined

Regards,

Rathy

[Former Member]

Calculate result as is already set to Nothing Defined.

[rathy_moorthy2]

so without using sumct its not working?

[Former Member]

Have tried without using SUMCT also....