Two Formula on same lie

[ksarker]

Hello,

i am working on a report with two quarters(current and prior) data. is that possible to have two formula together for receiving and paying company such as- 

Rec Company	Paying Company	Current Quarter	Prior Quarter
South	North	-2,500	500

this table above is based on following data 

Company Code	Trading Partner	Current Quarter	Prior Quarter
South	North	-2,500
North	South		500

please note (+) is outflow for Company code and (-) is Inflow for Company Code, 

[echuong1]

Yes, you can pivot the data so you have it in a vertical format, grouping by the company names. From there, you can assign a record ID - this will correspond to each line in the final output. You can then pivot back to the get values in separate columns.

I added a data cleansing since you had a lot of leading/trailing spaces and a select to remove the ID field created.

[ksarker]

thanks for your quick response. but can i use IF formula from formula tool for both current and prior quarter data  

[echuong1]

You cannot create additional/new rows of data with a formula tool, since it will use your existing rows of data and process row-by-row.

You can use a process similar to what I outlined above or the generate rows to do this.