Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Iterate an operation between rows

Hi everyone. I've got a table with the following columns: Item ID Date Warehouse ID Stock quantity Unitary cost of each item Stock value (for each item) Moved quantity (for sales)   ...
Need Help
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    I am not sure if I understood it correctly, you can add a column as follows:

    New Column = IF( [Quantita_movimentata] <> Blank() , [Quantita_in_Stock]-[Quantita_movimentata])


     

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

I am not sure if I understood it correctly, you can add a column as follows:

New Column = IF( [Quantita_movimentata] <> Blank() , [Quantita_in_Stock]-[Quantita_movimentata])


 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you.