topic how to calculate amount based on discount % in QlikView https://community.qlik.com/t5/QlikView/how-to-calculate-amount-based-on-discount/m-p/1648723#M447798 <P>Dear Team,</P><P>&nbsp;</P><P>Hope you are doing well!!!!!!!!</P><P>i Stuck a Requirement. i am calculating amount based on discount% as per given in excel.My Amount is&nbsp;<STRONG>900000.</STRONG></P><P><STRONG>i&nbsp;</STRONG>want to calculate amount based on slab no.1,Slab no.2 And Slab no.3.</P><P>Means</P><P>0-300000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;discount 35%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300000*.35=105000</P><P>300000-500000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;discount 30%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100000*.30=30000</P><P>500000-1000000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; discount 25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500000*.25=125000</P><P>&nbsp;</P><P>900000 lakh divided in three slabs.i am giving excel according to slab wise.kindly attached the excel.</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:38:21 GMT panipat1990 2024-11-16T19:38:21Z how to calculate amount based on discount % https://community.qlik.com/t5/QlikView/how-to-calculate-amount-based-on-discount/m-p/1648723#M447798 <P>Dear Team,</P><P>&nbsp;</P><P>Hope you are doing well!!!!!!!!</P><P>i Stuck a Requirement. i am calculating amount based on discount% as per given in excel.My Amount is&nbsp;<STRONG>900000.</STRONG></P><P><STRONG>i&nbsp;</STRONG>want to calculate amount based on slab no.1,Slab no.2 And Slab no.3.</P><P>Means</P><P>0-300000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;discount 35%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300000*.35=105000</P><P>300000-500000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;discount 30%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100000*.30=30000</P><P>500000-1000000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; discount 25%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500000*.25=125000</P><P>&nbsp;</P><P>900000 lakh divided in three slabs.i am giving excel according to slab wise.kindly attached the excel.</P><P>&nbsp;</P> Sat, 16 Nov 2024 19:38:21 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-amount-based-on-discount/m-p/1648723#M447798 panipat1990 2024-11-16T19:38:21Z