
Re: Set Analysis  Basic BODMAS
Avinash R Jul 9, 2014 4:05 AM (in response to Jayanthan Sivaloganathan)
Re: Set Analysis  Basic BODMAS
Jayanthan Sivaloganathan Jul 9, 2014 4:50 AM (in response to Avinash R )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))

Re: Set Analysis  Basic BODMAS
Jayanthan Sivaloganathan Jul 9, 2014 4:51 AM (in response to Jayanthan Sivaloganathan)where
FULL FOB = X
PACK = Y

Re: Set Analysis  Basic BODMAS
Avinash R Jul 9, 2014 5:24 AM (in response to Jayanthan Sivaloganathan)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.

Re: Set Analysis  Basic BODMAS
Jayanthan Sivaloganathan Jul 9, 2014 5:34 AM (in response to Avinash R )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

Re: Set Analysis  Basic BODMAS
Avinash R Jul 9, 2014 5:49 AM (in response to Jayanthan Sivaloganathan)
Re: Set Analysis  Basic BODMAS
Jayanthan Sivaloganathan Jul 9, 2014 7:38 AM (in response to Avinash R )wow, sorted
thank you all
Cheers

Re: Set Analysis  Basic BODMAS
Avinash R Jul 9, 2014 7:45 AM (in response to Jayanthan Sivaloganathan)Hi Jayanthan,
If the issue is resolved please mark it as Answered
Regards,
@vi





Re: Set Analysis  Basic BODMAS
Satyadev Jaiswal Jul 9, 2014 5:31 AM (in response to Jayanthan Sivaloganathan)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))



Re: Set Analysis  Basic BODMAS
Vidhya Annamalai Jul 9, 2014 5:19 AM (in response to Jayanthan Sivaloganathan)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

Re: Set Analysis  Basic BODMAS
Satyadev Jaiswal Jul 9, 2014 5:26 AM (in response to Jayanthan Sivaloganathan)Your expression should be,
Sum( Aggr( Sum( x )/Sum( y ), dimension ) )