topic Re: PROFIT in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972246#M377 <P>hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47228">@sagaraperera</a>&nbsp;</P> <P>can you provide more details on exactly what you are looking for?</P> <P>&nbsp;the above one you asked for is a simple calculation. you can do it by preceding load if the first column is a list of fields.</P> Wed, 24 Aug 2022 04:35:14 GMT Rajashekar 2022-08-24T04:35:14Z PROFIT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972235#M376 <P>DEAR ALL</P> <P>PLEASE HELP GET A ANSWER IN FOLLOWING</P> <TABLE width="312"> <TBODY> <TR> <TD width="172">DESCRIPTION</TD> <TD width="76">ACTUAL</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>POLICY_FEES</TD> <TD>30,180</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>GROSS_PROFIT</TD> <TD>5,000,052</TD> <TD>A</TD> </TR> <TR> <TD>STAFF_EXPENSES</TD> <TD>914,995</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>ADMIN_EXPENSES</TD> <TD>2,275,399</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>SELLING_EXPENSES</TD> <TD>964,524</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>FINANCIAL_EXPENSES</TD> <TD>12,874</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>DEPRICIATION_EXPENSES</TD> <TD>23,460</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>MANAGEMENT_EXPENSES</TD> <TD>4,191,252</TD> <TD>B</TD> </TR> <TR> <TD>INV_INCOME_INT</TD> <TD>5,084</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>OTHER_INCOME_EXT</TD> <TD>0</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>OTHER_INCOME_INT</TD> <TD>-34,122</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>INV_OTHER_INCOME</TD> <TD>-29,038</TD> <TD>C</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>NET_PROFIT</TD> <TD><STRONG>A-B+C</STRONG></TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>ANSWER</TD> <TD><STRONG>779,762</STRONG></TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>SANKA</P> <P>&nbsp;</P> Wed, 24 Aug 2022 03:53:18 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972235#M376 sagaraperera 2022-08-24T03:53:18Z Re: PROFIT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972246#M377 <P>hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47228">@sagaraperera</a>&nbsp;</P> <P>can you provide more details on exactly what you are looking for?</P> <P>&nbsp;the above one you asked for is a simple calculation. you can do it by preceding load if the first column is a list of fields.</P> Wed, 24 Aug 2022 04:35:14 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972246#M377 Rajashekar 2022-08-24T04:35:14Z Re: PROFIT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972258#M378 <P>Dear Rajeshkar</P> <P><SPAN>please find the below attachment and i want get a net profit value in calculation. please help</SPAN></P> <P>&nbsp;</P> <P><SPAN>sagara&nbsp;</SPAN></P> <P>&nbsp;</P> Wed, 24 Aug 2022 05:15:14 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/PROFIT/m-p/1972258#M378 sagaraperera 2022-08-24T05:15:14Z