https://community.qlik.com/t5/App-Development/Combine-two-fields-into-one-field/m-p/1537967#M38830 <P>You wouldn't concatenate these fields.&nbsp;</P><P>Create a calculated field in the data manager.&nbsp;</P><P>the field would be the following:</P><P>[Opening debit bal] - [Opening credit bal]&nbsp;&nbsp;</P><P>Title the new field Opening bal &amp; you are good to go!</P><P>Good luck!</P> Thu, 31 Jan 2019 15:43:37 GMT kelley_a 2019-01-31T15:43:37Z https://community.qlik.com/t5/App-Development/Combine-two-fields-into-one-field/m-p/1537961#M38829 <P>Hi All,</P><P>I'm trying to combine my [Opening debit bal] and [Opening credit bal] into one field called [Opening Balance]. However, when I try to concatenate the two fields together, the results are skewed because it also tacks on the 0.00 value at the end so I'll get 7500 instead of 750.</P><P>I'm not sure how to exclude the zeros from being added onto my amounts. Does anyone have any insight on how to do this?</P><P>Thank you!&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ahp_error5.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4963i280EA26C19C71D69/image-size/large?v=v2&amp;px=999" role="button" title="ahp_error5.PNG" alt="ahp_error5.PNG" /></span></P> Sat, 16 Nov 2024 06:42:23 GMT https://community.qlik.com/t5/App-Development/Combine-two-fields-into-one-field/m-p/1537961#M38829 mijileee 2024-11-16T06:42:23Z https://community.qlik.com/t5/App-Development/Combine-two-fields-into-one-field/m-p/1537967#M38830 <P>You wouldn't concatenate these fields.&nbsp;</P><P>Create a calculated field in the data manager.&nbsp;</P><P>the field would be the following:</P><P>[Opening debit bal] - [Opening credit bal]&nbsp;&nbsp;</P><P>Title the new field Opening bal &amp; you are good to go!</P><P>Good luck!</P> Thu, 31 Jan 2019 15:43:37 GMT https://community.qlik.com/t5/App-Development/Combine-two-fields-into-one-field/m-p/1537967#M38830 kelley_a 2019-01-31T15:43:37Z