Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
For QS
=Sum({<Codes = {'QS'}>}[Qty Sold])
For QA
=Sum({<Codes = {'QA'}>}[Qty Sold])
What is the expected output you are looking to see and which type of object?
hey sunny,
would like to see a text object with a count of locations when
Codes=
QS---Quantity Sold
QA---Quantity onHand
Thanks,
D
For QS
=Sum({<Codes = {'QS'}>}[Qty Sold])
For QA
=Sum({<Codes = {'QA'}>}[Qty Sold])
Thank you sunny
Sunny One more question, Is there a way to show the number of locations reporting sales and inventory on a test object
May be this
=Count(DISTINCT{<Codes = {'QS'}>}Location)
=Count(DISTINCT{<Codes = {'QA'}>}Location)
Got it, Sorry this is my question first time when I asked could have properly mentioned