count of locations by Qty Sold and Qty Onhand

[dseelam]

Hello All,

Attached Qvw has qty BY CODES

Would like to caliculate count of QTY locations by sales and inventory

Can somebody please help

Codes

  QS---Quantity Sold

QA---Quantity onHand

  QP--- Quantity onOrder

Thanks,

Dinesh

[sunny_talwar]

What is the expected output you are looking to see and which type of object?

[dseelam]

hey sunny,

would like to see a text object with a count of locations when

Codes=

QS---Quantity Sold

QA---Quantity onHand

Thanks,

D

[sunny_talwar · Accepted solution]

For QS

=Sum({<Codes = {'QS'}>}[Qty Sold])

For QA

=Sum({<Codes = {'QA'}>}[Qty Sold])

[dseelam]

Thank you sunny

[dseelam]

Sunny One more question, Is there a way to show the number of locations reporting sales and inventory on a test object

[sunny_talwar]

May be this

=Count(DISTINCT{<Codes = {'QS'}>}Location)

=Count(DISTINCT{<Codes = {'QA'}>}Location)

[dseelam]

Got it, Sorry this is my question first time when I asked could have properly mentioned