Forum Discussion

argnist's avatar
argnist
Frequent Visitor
8 years ago
Solved

Divide summarized column by another summarized column

Hi all,   does anyone know the way to divide one summarized column over to another summarized column?   When I try something like SUM (Total Sales) / SUM (Items Sold) it calculates it for each it...
  • vcastello's avatar
    vcastello
    8 years ago

    Hi argnist

    Try the following:

    1.- Click New Measure.

    2.- Enter
             Average Per Item = DIVIDE([Total Sales], [Items Sold])

    3.- Put that new measure in the matrix

    Hope That Helps

    Vicente

vcastello's avatar
vcastello
Resolver III
8 years ago

Hi Kulchandra,

 

Try ....

Measure1 = DIVIDE(DIVIDE([Count Of Badges ID],[Duration Seconds]),60)

 

Hope That helps

 

Vicente