Mind-boggling that my Report Text Tool was returning Null Values

[jwang357]

The Report Text Tool was giving me null values for two fields, "Region" and " Changes in monthly Sales", respectively ;

Hopefully somebody could spot what was the problem.

My workflow as attached here.

xl data was cleaned.

Many Thanks

jenny

[Bren_Spill]

@jwang357 - In the table tool after the formula tool where you create changes in monthly sales, rename the new field to something other than Changes in Monthly Sales and that should work:

[jwang357 · Accepted solution]

Wow Bren, such a fast problem solver !!

One more missing piece of the jig saw puzzle, could somebody tell me why the Browse output was returning Region as a null value ?

See attached workflow

Many thanks once again !

[Bren_Spill]

@jwang357 - please accept as solution if this worked for you. Thanks!

[Bren_Spill · Accepted solution]

@jwang357 - sorry I missed your question about the Region. It's the same issue as the Changes in Monthly Sales. The field you are including in the body of the text tool cannot have the same name as the field name in Create new field for this text -  i.e.:1 and 2 in the screen shot below can't be the same

Thanks!

[jwang357 · Accepted solution]

Awesome Bren !!  both of your solutions had worked like magic !!!

Gratitude !!!