topic Re: How to calculte COGS in QlikView https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1175#M794520 <HTML><HEAD></HEAD><BODY><P>you mean above data is wrong?</P></BODY></HTML> Tue, 16 Jan 2018 09:22:46 GMT Anonymous 2018-01-16T09:22:46Z How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1167#M794512 <HTML><HEAD></HEAD><BODY><P>Hello everyone</P><P></P><P>i am trying to create dummy dashboard from financial data. i have below data.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190187_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>but i am not getting one thing how COGS calculate in that.</P><P></P><P>i have below formula ..</P><P>COGS=Beginning Inventory+Purchase- Ending Inventory</P><P></P><P>from above data i don't know which one is beginning and end inventory.</P><P></P><P>Please Help me to find out..</P><P></P><P></P><P>Thanks...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1167#M794512 Anonymous 2020-11-25T16:16:04Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1168#M794513 <HTML><HEAD></HEAD><BODY><P>Please contact to your Sales team related Data and request them to create Flag for differentiate each. That demon the issue</P></BODY></HTML> Tue, 16 Jan 2018 08:21:58 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1168#M794513 Anil_Babu_Samineni 2018-01-16T08:21:58Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1169#M794514 <HTML><HEAD></HEAD><BODY><P>its a dummy data.</P></BODY></HTML> Tue, 16 Jan 2018 08:31:46 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1169#M794514 Anonymous 2018-01-16T08:31:46Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1170#M794515 <HTML><HEAD></HEAD><BODY><P>COGS is Cost of goods sold so it should be&nbsp; = Quantity * Units Price*</P></BODY></HTML> Tue, 16 Jan 2018 09:02:01 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1170#M794515 vinieme12 2018-01-16T09:02:01Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1171#M794516 <HTML><HEAD></HEAD><BODY><P>but there is no quantity col.</P></BODY></HTML> Tue, 16 Jan 2018 09:09:24 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1171#M794516 Anonymous 2018-01-16T09:09:24Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1172#M794517 <HTML><HEAD></HEAD><BODY><P>that should be the "Units Sold" * "Unit Price"</P></BODY></HTML> Tue, 16 Jan 2018 09:10:43 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1172#M794517 vinieme12 2018-01-16T09:10:43Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1173#M794518 <HTML><HEAD></HEAD><BODY><P>Gross Sales=unit sold * unit Price or sales price.</P></BODY></HTML> Tue, 16 Jan 2018 09:16:18 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1173#M794518 Anonymous 2018-01-16T09:16:18Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1174#M794519 <HTML><HEAD></HEAD><BODY><P>Gross sales should be Sales PRice * Unit Price!!</P></BODY></HTML> Tue, 16 Jan 2018 09:18:21 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1174#M794519 vinieme12 2018-01-16T09:18:21Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1175#M794520 <HTML><HEAD></HEAD><BODY><P>you mean above data is wrong?</P></BODY></HTML> Tue, 16 Jan 2018 09:22:46 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1175#M794520 Anonymous 2018-01-16T09:22:46Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1176#M794521 <HTML><HEAD></HEAD><BODY><P>start with the demo apps that come along with the installation of Qlikview</P></BODY></HTML> Tue, 16 Jan 2018 09:29:32 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1176#M794521 vinieme12 2018-01-16T09:29:32Z Re: How to calculte COGS https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1177#M794522 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>COGS is Units Sold * Manufacturing Price</P><P>the sale is Units Sold * sales price</P><P></P><P>i think manufacturing price is an issue in your data...and also they multiplied by 10 </P></BODY></HTML> Tue, 16 Jan 2018 14:53:06 GMT https://community.qlik.com/t5/QlikView/How-to-calculte-COGS/m-p/1177#M794522 andrei_delta 2018-01-16T14:53:06Z