Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you multiplying 1000000 with the whole or denominator only? Please verify.
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)
with Whole
Sorry Kush same issue!
Thanks,
AS
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
Sasidhar,
I have already tried this , upper part alone is working fine but below part always showing me zero.
Thanks,
AS
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
Can you please attach your sample application.
Made mistake, you may need bracket before Sum..