I need your assistance.
I am extracting some info from my database and I need difference between two fields of money values.
Lets call the fields as Field1,Field2,& Field3.
Field1 = Current Balance
Field2 = Starting Balance
Field3 = Field1 - Field2
From my query, I get Field3 as NULL. I cant understand what is wrong with my formula.
Here is the formula:
Declare @Field1 numeric (18,2), @Field2 numeric (18,2), @Field3 numeric (18,2) Select Field1 = @Field1 , Field2 = @Field2 Select @Field3 = @Field1 - @Field2 Select @Field3
Please assist. TQ.