https://community.qlik.com/t5/QlikView/Division/m-p/1536617#M439196 <P>Hi,</P><P>I am new to QlikSense and trying the below formula to divide two fields and not able to get the correct answer.&nbsp;</P><P>num(sum({&lt;$(VComparePeriod)&gt;}"Sales")/Sum({&lt;$(VComparePeriod)&gt;}"No. of days"),'#.00%')</P><P>This formula gives same output/answer for all the&nbsp;days, weeks and months which does not match the pivot.&nbsp;</P><P>Tried the formula without variables as well, it throws an error.</P><P>Can&nbsp;someone please help?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 29 Jan 2019 15:43:59 GMT afshaarc 2019-01-29T15:43:59Z https://community.qlik.com/t5/QlikView/Division/m-p/1536617#M439196 <P>Hi,</P><P>I am new to QlikSense and trying the below formula to divide two fields and not able to get the correct answer.&nbsp;</P><P>num(sum({&lt;$(VComparePeriod)&gt;}"Sales")/Sum({&lt;$(VComparePeriod)&gt;}"No. of days"),'#.00%')</P><P>This formula gives same output/answer for all the&nbsp;days, weeks and months which does not match the pivot.&nbsp;</P><P>Tried the formula without variables as well, it throws an error.</P><P>Can&nbsp;someone please help?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 29 Jan 2019 15:43:59 GMT https://community.qlik.com/t5/QlikView/Division/m-p/1536617#M439196 afshaarc 2019-01-29T15:43:59Z