I want to subtract the 2 columns

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

Solved Solved
0 5 629
1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5

_redline
Participant IV

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?

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

how did you solve it

How did you solve it?

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

Top Labels in this Space