Multiplication Formula on Certain Rows

Question

I have a data output and some of my numbers are incorrectly negative (due to my ERP system data). I need to make them positive numbers. The issue is I only want some of them changed. I have attached my data sample.

I only want the following lines changed from negative to positive

Chern Sales

DBHL Sales

Oat Sales

QD Sales

I need 'Less Absorbed - FGB' and 'Less Absorbed - FGM' to stay negative.

Any suggestions how I can do this quickly?

Thanks!

Work Ex1.xlsx

LordNeilLord · Accepted Answer

Hey @britknip

I'd start by transposing the data first then using a formula like this:

If [FSParent] = 'Less Absorbed - FGB' ||
[FSParent] = 'Less Absorbed - FGM' Then Value Else
Abs([Value])
Endif

Then crosstab back again

ponraj · Accepted Answer

Hi @britknip,

Here is the solution.

1. Filter out the row which needs to be made positive.

2. Use multi field formula to multiply filtered out rows with -1

3. Then use union tool .