Skip to Content
0
Former Member
Mar 14, 2007 at 02:41 PM

result query

29 Views

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