Re: How to calculte COGS - Qlik Community

Anonymous · ‎2018-01-16

Hello everyone

i am trying to create dummy dashboard from financial data. i have below data.

but i am not getting one thing how COGS calculate in that.

i have below formula ..

COGS=Beginning Inventory+Purchase- Ending Inventory

from above data i don't know which one is beginning and end inventory.

Please Help me to find out..

Thanks...

Anil_Babu_Samineni · ‎2018-01-16

Please contact to your Sales team related Data and request them to create Flag for differentiate each. That demon the issue

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-01-16

its a dummy data.

vinieme12 · ‎2018-01-16

COGS is Cost of goods sold so it should be = Quantity * Units Price*

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2018-01-16

but there is no quantity col.

vinieme12 · ‎2018-01-16

that should be the "Units Sold" * "Unit Price"

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2018-01-16

Gross Sales=unit sold * unit Price or sales price.

vinieme12 · ‎2018-01-16

Gross sales should be Sales PRice * Unit Price!!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2018-01-16

you mean above data is wrong?

vinieme12 · ‎2018-01-16

start with the demo apps that come along with the installation of Qlikview

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.