ADD NEW RAW ( Condition )

[Remouters]

Hello Great community,

I need to your help

I have this Data Set

| DATE | Category |account number |Debit |
|2020-01-03|toyota |58200000 |2122.2 |
|2020-01-03|Mercedes |58300000 |1056.44 |
|2020-04-03|Toyota |58300000 |203.52| |
|2020-04-03|Mercedes |58300000 |953.4| |

and i’m trying to create a new columns called ( Credit ) and at the end of each Date set with the total of the above value to have this

| DATE | Category |account number |Debit | Credit |
|2020-01-03|toyota |58200000 |2122.2 |
|2020-01-03|Mercedes |58300000 |1056.44 |
|2020-01-03|Total day 1 |XXXXX |EMPTY | 3178,64|
|2020-04-03|Toyota |58300000 |203.52| |
|2020-04-03|Mercedes |58300000 |953.4| |
|2020-01-03|Total day 2 01010000| |EMPTY | 1156,92|

Any smart suggestions ?

Thanks a lot !

[bruno29a]

Hi @Remouters , there are many ways to add a column to a table.

But where are the data coming from? Are they being added manually, in which case would presumably mean that you want to add the column manually?

I mean, what’s your use-case here?

[Remouters]

Hello @bruno29a

It’s a accounting use case i need to prepare the file integrate it to my accounting software

| DATE | Category |account number |Debit |
|2020-01-03|toyota |58200000 |2122.2 |
|2020-01-03|Mercedes |58300000 |1056.44 |
|2020-04-03|Toyota |58300000 |203.52| |
|2020-04-03|Mercedes |58300000 |953.4|

i have to add the CREDIT COLLUMN ( manually ) with the calculation as explained above to obtain this Data

| DATE | Category |account number |Debit | Credit |
|2020-01-03|toyota |58200000 |2122.2 |
|2020-01-03|Mercedes |58300000 |1056.44 |
|2020-01-03|Total day 1 |XXXXX |EMPTY | 3178,64 |
|2020-04-03|Toyota |58300000 |203.52| |
|2020-04-03|Mercedes |58300000 |953.4| |
|2020-01-03|Total day 2 01010000| |EMPTY | 1156,92 |

so i can integrate in the accounting software

[bruno29a]

Hi @Remouters , thank you for the additional clarification.

So, I understand that the credit values are a sum of the debit values, but it looks like it’s also added as a new Row, correct? Are you able to add this row and are only struggling with adding the new column, in which case can you share your workflow, or do you need help to create the new row+column?

And to clarify, the Total needs to be done by day, determined by the dates, and by account number, correct?

EDIT: Is your sample data correct?
|2020-01-03|toyota |58200000 |2122.2 |
|2020-01-03|Mercedes |58300000 |1056.44 |

These are 2 different account numbers, but the Debits have been added together to get the CREDIT value in your sample. Does this mean we only aggregate per date, and not date + account number?

Can you please confirm?

[bruno29a]

Hi @Remouters , I’m assuming that it’s per DATE, based on your sample so I could put something together.

My input date (same as yours):

And this is what my workflow is producing:

Here’s the workflow: Accounting add credit column.knwf (21.4 KB)

[Remouters]

Very smart solution !

Thanks a lot !