missing results when using percentage function %GT

[Former Member]

Hi all,

I'm using the percentage function in BEx. As you can see in the left two columns, it works fine when the results are higher then 0,4. All the results less than 0,4 are set to 0. In the last column I calculated the results with an Excel formula.

Any Idea, what the problem can be?

4.392,080 1,5635 % 1,563481163

997,440 0,0000 % 0,355066085

4.761,680 1,6951 % 1,695050405

1.260,000 0,4485 % 0,448531508

469,600 0,0000 % 0,167166981

280.916,720 100,0000 %

280.916,720 100,0000 %

Many thanks in advance!

[Former Member]

Hi Neven,

I am experiencig the same problem with function %GT. Whenever the result is less than 0.4% it just displays 0. Have you found a solution for this issue yet?

Thanks

Fernando Mora

[former_member207028]

HI,

percentage function %GT will calculate % based on overall result, your requirement is to have percentage function with overall result ?

Percentage Share of Overall Result (%GT)

%GT <Operand>

This shows how high the percentage share is with regard to the overall result. The overall result is the outcome of aggregating the highest results level. Dynamic filters (filters that were not specified in the Query Designer) also play a role in calculating the overall result.

do the calculation manulally and check the values.

Regards

Daya Sagar

[Former Member]

hi Daya Sagar,

thanks for your response.

I've put an example in my question. Unfortunately, the format is somehow mismatch. Anyway, in the last column I've calculated the results manually. There seemst to be a kind of threshold, probably < 0,4 %. All the calculated values beyond 0,4 % are providing the result, for all below 0,4 % i get 0 as a result.

Cheers

Neven

[Former Member]

Dear Daya sagar,

Iam tried with taht functionality the query it self it is showing wrong and iam getting below error as result.

Diagnosis

The query contains a formula with the operator %RT. Therefore, the query cannot be released for OLE DB for OLAP.

The operators %GT, %RT, %CT, SUMGT, SUMRT, SUMCT and LEAF depend on the display of the list in the BEx Analyzer. If you used OLE DB for OLAP or MDX, this formula would deliver unexpected values.

Procedure

Do not release the query for OLE DB for OLAP, or do not use the operators %GT, %RT, %CT, SUMGT, SUMRT, SUMCT or LEAF. You may be able to achieve the desired result by selecting constants.

and report output is not coming.

Thanks & Regards,

Sathish