topic AW:Inputsum Calculation in QlikView https://community.qlik.com/t5/QlikView/Inputsum-Calculation/m-p/201509#M59566 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P>I find out, that INPUTSUM doesn't work with any IF-statement, by using '*' or '+' etc. too.</P></BODY></HTML> Fri, 25 Jun 2010 08:03:25 GMT brenner_martina 2010-06-25T08:03:25Z Inputsum Calculation https://community.qlik.com/t5/QlikView/Inputsum-Calculation/m-p/201508#M59565 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to some feedback in using INPUTSUM function. I am using "inputsum" in a pivot table. The below expression works fine..</P><P>INPUTSUM(KPI_INPUT) where i defined KPI_INPUT as input field in my script.</P><P>If i add sum condition in inputsum then it is not working. For eg.</P><P>INPUTSUM(IF(DATA_TYPE='D',NUM(KPI_INPUT,'####0'),IF(DATA_TYPE='F',NUM(KPI_INPUT,'####0.00'))))</P><P></P></BODY></HTML> Fri, 25 Jun 2010 06:35:19 GMT https://community.qlik.com/t5/QlikView/Inputsum-Calculation/m-p/201508#M59565 2010-06-25T06:35:19Z AW:Inputsum Calculation https://community.qlik.com/t5/QlikView/Inputsum-Calculation/m-p/201509#M59566 <HTML><HEAD></HEAD><BODY><P>Hi Rajesh,</P><P>I find out, that INPUTSUM doesn't work with any IF-statement, by using '*' or '+' etc. too.</P></BODY></HTML> Fri, 25 Jun 2010 08:03:25 GMT https://community.qlik.com/t5/QlikView/Inputsum-Calculation/m-p/201509#M59566 brenner_martina 2010-06-25T08:03:25Z