I want to subtract the 2 columns

[ekoy]

Table Name: Cash Balance

Column1: Total Money In
Column 2: Total Money Out
Column 3: Total

I already have a formula for Column 1 and 2. But I dont know what expression can i use for Column 3 to subtract Column 1 and 2

Expressions Unknown

=[Total Money In] - [Total Money Out]

I dont know what was the problem

[_redline]

What is the output to your expression in the expression editor? Does it flag an error when you put in the above formula into “Column 3”? If so, what is the error given?

[ekoy · Accepted solution]

Thank You for replying my post. I already fix it.

[Zic_Sochy1]

how did you solve it

[Nick_S]

How did you solve it?

[Loving]

La solucion erá colocar los campos a restar en modo "NUMBER"  y el campo del resultado tambien a NUMBER! es todo.