Distribution

[spividori]

Hi.

I have two tables, they are the following:

Table1:

Table2:

I need to distribute the amounts of table one in table two, as follows.

The data in both tables must be sorted by date desc.

This is an example, both tables have many data to process as the example.

I attach the sample data in Excel spreadsheets.

Can someone help me with this?

Regards.

[krishna20]

Hi Sandro,

Why dont you use link table concept here

Thanks

[spividori]

Hi, KALYAN.

Thanks for answering.

Sorry, I do not understand, how would that be?.

Regards.

[krishna20]

Hi could you please explain how you calculate importcal column

Thank,

Ram

[spividori]

Hi.

For the calculation of the column "AmountCalc" I take from the "Importe" column of Table1 and must be distributed in relation to the "ImpImport" column of Table2.

I hope you understand me, my English is poor.

Regards.