Script Problem

[#1]

Guys,

I have this script with two lines almost equal, except for their prices, and I am getting no values due to the same names, I believe. I want both to be shown in my chart "Food Price" (Third blue box in the script).

Can you guys script a way our of this problem for me please?

Thank you,

There it is the two files

[#2]

anyone?

[tresesco]

It seems that your Food_Price_substitute has multiple values for those intersections where you are gettinh a null/'-'. You should try expression like: = Sum(Food_Price_substitute ).

[#4]

That's not exactly what i would like to have... I would like to see two times, one written fish with cost 10, and another one with fish costing 7. Using Sum(Food_Price_substitute ) it shows only one time fish with the cost 17...

Is there a way to solve that?

[tresesco · Accepted solution]

Then take Food_Price_substitute as third dimension.

[#6]

This is it, just perfect tresesco.

Thank you, ALOT!