Charts showing null

[siddheshmane]

Hello all,

I have been facing this issue where I have to display an Inventory Value against a particular Brand but the bar chart does not plot anything. (No data to display).

My Dimension column contains Brand and in the Expressions I just add (Inventory Qty * Cost).  Somehow the Graph does not display anything. Whereas, when I change my Dimension from Brand to SKU the chart displays something (even if that is not the result i want).

I'm sure I am missing something here. What am I doing wrong

Thanks in advance,

Siddhesh

[ahaahaaha]

Hi,

Maybe expression ([Inventory Qty] * Cost)

[caio_caminoski]

Hi, try Sum(Inventory Qty * Cost) as your measure.

Regards,

Caio

[caio_caminoski]

Also, andrey is right, try

Sum([Inventory Qty] * Cost)

[siddheshmane]

Thank you for helping me out here.

I tried doing SUM but the Inventory Value goes waay beyond actual..

SUM gives me axis of 35,000,000

whereas it should actually be around 40,000-50,000

[ahaahaaha]

Can we see a fragment of your data?

[Clever_Anjos]

The correct formula depends on your datamodel.

Could you print your datamodel?

[siddheshmane]

Hi,

Apologies for the delay, Please find below QV file

Thank you

[tresesco]

If you use expression Sum(InventoryQty*[Unit Cost]), you get

and what do you expect to see?

[siddheshmane]

Thank you for your advice,

I tried using this expression. but the user said that the value isn't supposed to exceed 100000. Am i doing something wrong?

Thank you.