topic Re: Previous balance and Current balance by date and time by Cod load in App Development

Previous balance and Current balance by date and time by Cod load

Ribeiro — Mon, 08 May 2023 14:01:55 GMT

I need to make Balance in the Ant and Final

By Code, Date Time,

Any suggestion

Example code 9147,

I would like everyone's balance, follow the example spreadsheet.

Chanty4u — Mon, 08 May 2023 18:17:25 GMT

You can try this

Table1:

LOAD

[Data Hora],

Cod,

Tipo,

Ant,

Final

FROM [your_data_source.csv]

(ooxml, embedded labels, table i

s Sheet1);

Table2:

LOAD

[Data Hora],

Cod,

Tipo,

Ant,

Final,

if(Tipo = 'E', Peek('Final') + E - S, Peek('Final')) as Balance

Resident Table1

Order by Cod, [

Data Hora];