https://community.qlik.com/t5/App-Development/Convert-Formula-into-Value/m-p/1748361#M57537 <P>Hi,</P><P>I have a detailed sheet which contains complex formulas based on the details in this sheet.</P><P>The user wants to create pivots of this data in Qliksense, but when the formula is applied at the summary level then the totals are different.</P><P>What I want to do is save the convert the field in my detailed report into a value, so that I can then sum this value field in my pivot rather than trying to re-calculate using a formula.</P><P>&nbsp;</P> Wed, 30 Sep 2020 08:27:41 GMT HugoBoyle 2020-09-30T08:27:41Z https://community.qlik.com/t5/App-Development/Convert-Formula-into-Value/m-p/1748361#M57537 <P>Hi,</P><P>I have a detailed sheet which contains complex formulas based on the details in this sheet.</P><P>The user wants to create pivots of this data in Qliksense, but when the formula is applied at the summary level then the totals are different.</P><P>What I want to do is save the convert the field in my detailed report into a value, so that I can then sum this value field in my pivot rather than trying to re-calculate using a formula.</P><P>&nbsp;</P> Wed, 30 Sep 2020 08:27:41 GMT https://community.qlik.com/t5/App-Development/Convert-Formula-into-Value/m-p/1748361#M57537 HugoBoyle 2020-09-30T08:27:41Z https://community.qlik.com/t5/App-Development/Convert-Formula-into-Value/m-p/1748850#M57569 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/78138">@HugoBoyle</a>&nbsp;Would you be able to share a sample where we can see this?</P> Thu, 01 Oct 2020 13:39:33 GMT https://community.qlik.com/t5/App-Development/Convert-Formula-into-Value/m-p/1748850#M57569 sunny_talwar 2020-10-01T13:39:33Z