Set Analysis - Basic BODMAS

[#1]

Hi All

i wanted to divide X by Y first for Sales ID,Answer Z , so i want the aggregation of Z

E .g

x	y	Z
10	5	2
20	4	5
	Answer	7

[avinashelite]

Hi Jayanth,

Please use AGGR(x/y,Z) .... in the expression total select sum .

Hope this is what ur looking for.

[#3]

Hi

could you please verify the below expression  is correct

=Aggr((sum(if([SHIPPED QTY]>0 and [QTY VARIANCE]<0,[QTY VARIANCE],'0')))*-1)*(sum([FULL FOB])/sum(PACK))

[#4]

where

FULL FOB = X

PACK    = Y

[#5]

you missed dimension in aggr() function

=Aggr((sum(if([SHIPPED QTY]>0 and [QTY VARIANCE]<0,[QTY VARIANCE],'0')))*-1,DIMENSION)*(sum([FULL FOB])/sum(PACK))

use your respective dimension name instead of dimension

[avinashelite]

Try like this

Aggr(if([SHIPPED QTY]>0 and [QTY VARIANCE]<0,sum([QTY VARIANCE],0)*(sum([FULL FOB])/sum(PACK)),Z)

Where Z is the field on which you need to do the aggregation.

[Anonymous]

Your expression should be,

Sum( Aggr( Sum( x )/Sum( y ), dimension ) )

[Anonymous]

Hi,

You need to add dimension in aggregation and finally enclose with sum function.

=Sum(Aggr((sum(if([SHIPPED QTY]>0 and [QTY VARIANCE]<0,[QTY VARIANCE],'0')))*-1)*(sum([FULL FOB])/sum(PACK), Dimension))

[#9]

hi both

thank you for the support

But i have little messed up with this . i wanted to divide Full Pack (X) by Pack(Y) and then add them .

E.g

X =10,20

Y = 5,10

so what i want  is(10/5) +(20/10)= 4

whereas my script reads them as (10+20) /(5+10)=2 which is incorrect

Sorry for the inconvenience caused

[avinashelite · Accepted solution]

Try like this

sum([Full Pack]/[Pack])...this will give u the result