Formula to total a null column is not showing in output

[lamor]

We have a formula set up to total once a row becomes null. Based on the formula it looks like it is calculating (2nd image). We then join it with other data and we get 0 instead of the total amount. The other columns are totaling as they should. 

[OllieClarke]

@lamor can you show your formula for column [1] please, as that seems to be the problem value?

[nagakavyasri]

@lamor Could you post the formula used to calculate the columns? Also, you can try to debug the workflow at each point till the join to understand where the data is changing.

[lamor]

Yes formula for column 1 attached and working formulas 

[lamor]

Here are the formulas. I used a browse tool at the formula and it looks like the formula is not calculating as I thought?

[CoG]

What are you trying to calculate? It looks like the formulae are calculating just fine, since all they do is replace null values with 0.

[lamor]

It should be calculating all the rows above it. The highlighted row is the total row for the other 2 columns, which is calculating appropriately. 

[MelGibson]

Are you able to post a mock workflow?

[lamor]

Sure, Would this just be a screenshot of the entire workflow? 

[CoG · Accepted solution]

It looks like the issue here is occurring before the Union Tool. That's where I would focus my attention. What are you getting after the Summarize and Cross Tab Tools?