Formula column in MS Query

Topic

New Reply

Hi,

I’m new here so apologies if I get things a bit wrong.
I am trying to create a column in MS Query. I have a column that indicates if a record is an Invoice or Credit. I want to bring in the value of the record however all values return as positive figures. I am trying to enter a “formula” to show credits as a negative figure.

Any help would be appreciated

Reply | Quote

Replies

Hi dan

Welcome to the Lounge as a new Poster!

Not quite clear on what you have.
Are you saying you have a data table, where one of the columns shows a record type as either Invoice or Credit, and another column that just has a positive amount?
If you headings were in row1, and ‘Type’ was in say, column [D], and positive ‘Value’ was in say, column [F], then you could have a column, say column [G], as ‘Amount”.
Then the formula in column [G] would simply be..
[G2] = IF(D2=”Credit”, -F2, F2)
..and copied down etc etc etc.

zeddy

Reply | Quote

What data source are you extracting from?

Reply | Quote