Combine two fields into one field

[mijileee]

Hi All,

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.

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?

Thank you! 

[kelley_a · Accepted solution]

You wouldn't concatenate these fields. 

Create a calculated field in the data manager. 

the field would be the following:

[Opening debit bal] - [Opening credit bal]  

Title the new field Opening bal & you are good to go!

Good luck!