Line chart, trying to add two measures

[D19PAL]

Hi Guys,

Line chart, trying to add two measures, 1 measure works perfect on its own, but if I try to add two of them together, I'm not getting all the fields from the Dimension that I'm using.

This is the 1st measure

 avg(cost)/avg(weight)

This is 2nd measure 

 avg(cost_new)/avg(weight_new)

They work alone, but when I do this

 avg(cost)/avg(weight)  + avg(cost_new)/avg(weight_new)

I'm only getting the Dimension fields from one of the measure, not both.

I hope someone can resolve this.

Thanks 

[MayilVahanan]

HI @D19PAL 

Try like below

(avg(cost)/avg(weight))  + (avg(cost_new)/avg(weight_new))

if not, can you give sample file

[D19PAL]

Thanks 

But I tried that too, doesn't work 

[D19PAL]

Anyone?  please lol

[MikeA · Accepted solution]

Could it be that one of the sides of the is trying to divide by zero and causing a null which then knocks out the other side of the expression?

try this - rangesum(avg(cost)/avg(weight),avg(cost_new)/avg(weight_new))?

[D19PAL]

Worked a treat.

Thanks