Get Previous Month Value

Hello
Iam civil engineer and working in construction company
we monthly payment for client
first we make progress report for actual total work till now
and we update this progress every payment
and after that we make payment for total quantity and deduct previos payment quantity as shown in doc shared
after that wemake summary table
which include total amount and previos amount and net amout
net amout will be added to finance table
please help me to get the previous quantity and previos amount
this is link to my doc

Hello @Mohamed_Elrefae,

I invite you to follow the screenshot and to use the number part which gives the values according to its interval.

I created a document https://coda.io/@thierryvm/manager-budget-personnel-vf and I add you screenshots :slight_smile:
P.S : This tip comes from @Christiaan_Huizer , thanks to him

Sincerely,
@codafrench - Thierryvm

nextPayment

Capture d’écran 2023-01-26 192208

Thank You Very much
the doc you shared not available
and i didnot understand this formula
can you apply it in my doc

1 Like

Hello @Mohamed_Elrefae,

I have applied an example in your document :), if you are ok with it, please mark it as resolved ^^

Sincerely,
@codafrench - Thierryvm

thank you for your help
you did great job
but what i need is in progress page

that incluide progress table and
Pay Details No 2
Pay Details No 2

Iwant previous month value to get by formula not manual

1 Like

I’m sorry if I misinterpreted your request, but at the moment, it is difficult for me to help you more, because I am in the hospital.

Sincerely,
@codafrench - Thierryvm

thank you very much for your help

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.