Measure is not working in Pie chart

[Ashutosh11]

I'm trying this measure in pie chart or KPI but it's not working:

(sum(Sales_QTY)*(Count( distinct replacement_jobsheet)/sum(Sales_QTY))/(NUM((created_on-purchase_date)*0.0328767)/num#(warranty_c)))

[Aditya_Chitale]

Did you try converting num#(warranty_c)  to  num(num#(warranty_c)) ? Also check if 'created_on-purchase_date' field contains date values. Sometimes converting date values to num returns null values.

Hope this helps

Regards,

Aditya

[Ashutosh11]

Thanks for replying Aditya.

I have tried to convert 'created_on-purchase_date' in num and its shows as values , but expression not worked in pie.

[MayilVahanan]

Hi

warranty_c & created_on-purchase_date -- do you have only one value for these fields?
if not, its throws null values [because, it doesn't know which value need to return].