https://community.qlik.com/t5/App-Development/Error-in-Dual-If-logic/m-p/2034520#M85252 <P>Hi All,</P> <P>Need to change the KPI values in the dashboard where I am using the below logic for multiple time periods, which gives me a calculation error. Can you please help me here where actually I am going wrong.</P> <P><BR />sum(IF(<STRONG>TIME_BUCKET</STRONG>='YTD' and [SALE_DATAMART-1.R17W]='Y',VALUES))-(sum(if(<STRONG>TIME_BUCKET</STRONG>='YTD' and PREV_R17W='Y',VALUES)))</P> <P>/sum(if(<STRONG>TIME_BUCKET</STRONG>='YTD' AND PREV_R17W='Y',VALUES,</P> <P><BR />sum(IF(<STRONG>TIME_BUCKET</STRONG>='TTD' and [SALE_DATAMART-1.R17W]='Y',VALUES))-(sum(if(<STRONG>TIME_BUCKET</STRONG>='TTD' and PREV_R17W='Y',VALUES)))</P> <P>/sum(if(<STRONG>TIME_BUCKET</STRONG>='TTD' AND PREV_R17W='Y',VALUES))</P> Mon, 06 Feb 2023 15:29:52 GMT Ankit3 2023-02-06T15:29:52Z https://community.qlik.com/t5/App-Development/Error-in-Dual-If-logic/m-p/2034520#M85252 <P>Hi All,</P> <P>Need to change the KPI values in the dashboard where I am using the below logic for multiple time periods, which gives me a calculation error. Can you please help me here where actually I am going wrong.</P> <P><BR />sum(IF(<STRONG>TIME_BUCKET</STRONG>='YTD' and [SALE_DATAMART-1.R17W]='Y',VALUES))-(sum(if(<STRONG>TIME_BUCKET</STRONG>='YTD' and PREV_R17W='Y',VALUES)))</P> <P>/sum(if(<STRONG>TIME_BUCKET</STRONG>='YTD' AND PREV_R17W='Y',VALUES,</P> <P><BR />sum(IF(<STRONG>TIME_BUCKET</STRONG>='TTD' and [SALE_DATAMART-1.R17W]='Y',VALUES))-(sum(if(<STRONG>TIME_BUCKET</STRONG>='TTD' and PREV_R17W='Y',VALUES)))</P> <P>/sum(if(<STRONG>TIME_BUCKET</STRONG>='TTD' AND PREV_R17W='Y',VALUES))</P> Mon, 06 Feb 2023 15:29:52 GMT https://community.qlik.com/t5/App-Development/Error-in-Dual-If-logic/m-p/2034520#M85252 Ankit3 2023-02-06T15:29:52Z https://community.qlik.com/t5/App-Development/Error-in-Dual-If-logic/m-p/2034678#M85278 <P>You seem to be missing at least two closing parens on the second line. Even then it would not be correct because you have two separate expressions.&nbsp; Is it that you want one calculation for YTD and another for TTD?</P> <P>Is TIME_BUCKET a dimension in your chart?</P> <P>-Rob</P> Mon, 06 Feb 2023 23:59:12 GMT https://community.qlik.com/t5/App-Development/Error-in-Dual-If-logic/m-p/2034678#M85278 rwunderlich 2023-02-06T23:59:12Z