Script Help???

[amit_saini]

Hi Folks ,

Below is my expression :

Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0))

*1000000

I'm calling a bar chart with Month as Dimension , but I'm getting "no data displayed value" when I'm calling above expression.

Not sure If my expression is correct or not?

Kindly suggest!

Thanks

AS

[Digvijay_Singh]

Are you multiplying 1000000 with the whole or denominator only? Please verify.

[Kushal_Chawda]

try this

=Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/

(alt(pick(match(Complaint_Type,'3','1','2','7'),

Sum (QTY_Delivered_TOTAL),Sum (QTY_Delivered_TOTAL), Sum (QTY_Received_TOTAL), Sum (QTY_Received_TOTAL)),0)

*1000000)

[amit_saini]

with Whole

[amit_saini]

Sorry Kush same issue!

Thanks,
AS

[sasiparupudi1]

I would separately put the expressions in a text object and see whats going on

Sum({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)

if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0))

hth

Sasi

[amit_saini]

Sasidhar,

I have already tried this , upper part alone is working fine but below part always showing me zero.

Thanks,

AS

[Digvijay_Singh]

But currently it is multiplying with denominator only, try this to multiply to whole -

=Sum(({<Complaint_Acceptance-={'4','5','6','7'}>} QTY_PPM*Top_Pos_Flag)/

  if(Complaint_Type=3 or Complaint_Type=1, Sum (QTY_Delivered_TOTAL),if(Complaint_Type=2 or Complaint_Type=7, Sum (QTY_Received_TOTAL), 0)))*1000000

[agni_gold]

Can you please attach your sample application.

[Digvijay_Singh]

Made mistake, you may need bracket before Sum..