Hi
I have a four column pivot table from a five column data table. The missing column is an account number that repeats itself on each row from the data table. The PT sums up and totals each of the division costs. Some divisions repeat and may have a negative, positive or 0 value. Some zero values may have decimal places beyond three.
I need to look at each line, and use an if statement something like
if (round (column3 amount),2)<>0 or if(round(column4 amount),2)<>0 then the row and move to a different table, otherwise don't copy and move to the next row))))))
I hope that makes sense.
Now I was hoping someone could help me out with this. More so that I learn from what you've done to help.
I'm not familiar with PTs all that much; and I'm not familiar with arrays although I'm trying to read about them both.
Thank you and good luck
- g
I have a four column pivot table from a five column data table. The missing column is an account number that repeats itself on each row from the data table. The PT sums up and totals each of the division costs. Some divisions repeat and may have a negative, positive or 0 value. Some zero values may have decimal places beyond three.
I need to look at each line, and use an if statement something like
if (round (column3 amount),2)<>0 or if(round(column4 amount),2)<>0 then the row and move to a different table, otherwise don't copy and move to the next row))))))
I hope that makes sense.
Now I was hoping someone could help me out with this. More so that I learn from what you've done to help.
I'm not familiar with PTs all that much; and I'm not familiar with arrays although I'm trying to read about them both.
Thank you and good luck
- g