result query

[Former Member]

Hi all,

I have a query with three key figure in the column : sales, revenue and

DLO = sales/revenue.

Actually the result of DLO is the summation of the column but I want that result is derivation from the formula

Example :

- Actually

REVENUE SALES DLO

532,15 13.835,90 26

223,20 1.339,20 6

TOTALE 755,35 15.175,10 32

Instead I need that is like follow:

REVENUE SALES DLO

532,15 13.835,90 26

223,20 1.339,20 6

TOTALE 755,35 15.175,10 20,09 where 20,09 = 15175,10 / 775,35

How can I do it?

Thanks a lot

Gianmarco

[Former Member]

Hi,

I'm not need a percentage, unfortunately formula collision is not right.

Can you help me?

Thanks

Gianmarco

[Former Member]

Hi,

Can you Please let me know how you are getting values for DLO 26,6.

REVENUE SALES DLO

532,15 13.835,90 26

223,20 1.339,20 6

755,35 15.175,10 32

By Adding SALES & REVENUE or by Dividing SALES by REVENUE.

If we Add SALES & REVENUE for DLO we will get 53228.84,22321.3392.

if Divided SALES by REVENUE for DLO we will .000026,0.00006

Thanks,

-Vijay

[Former Member]

by Dividing SALES by REVENUE then:

15.175,10 / 755,35 = 20,09

Thanks

Gianmarco

[Former Member]

You have to define formula collision as "Result from Competing Formula"! and

in calculated key figure properties where you specify "After Aggregation" in properties for "Time of Calculation".

Hope it helps.

Regards

[Former Member]

If I choose "After Aggregation" i'm not possibilty to choose "Result from Competing Formula"

Thanks

[Former Member]

Hi,

Just Goto the Properties of the DLO formula.Select 'Result from this formula' from the Dropdown of <b>Formula Collision</b>.

Hope it solves the Problem.

Thanks,

-Vijay

[Former Member]

Use CT percentage function available in bex.

Hope it helps.

Regards