How can i formulate these columns?

[Audit_CKGoC]

[Overdue] - Start compounding at the 7th month overdue.
[Interest]- Add 2% at the 7th month overdue.

[Aurelien]

Hi @Audit_CKGoC

I’m not at ease with Interest calculation, and I think I’m not the only one in this situation

Can you share the expression stored in the yellow column ?

[Audit_CKGoC]

its [overdue] times [interest]

[Aurelien]

OK, but I think some informations are missing.
You may want to use a combination with EOMONTH(): this requires having a date somewhere.

help.appsheet.com

EOMONTH()

Date of last day of a month from Date or DateTime

Can you be more explicit about your questions ?
Also, I suggest you have a look there:

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

[Craig_QREW]

You would need to have the date that this item was due in order to do this.
An expression you could use is taking the interest column and using what the above post states about the EOMONTH() function. Write an expression saying that IF(today()>=EOMONTH([Overduedate],6)+1,[_THISROWBEFORE].[Interest]+2=[_THISROWAFTER].[Interest],0)
And his would go in the formula field for the interest column.
Something very similar to that ought to work for you. I recommend looking into _THISROWBEFORE and _THISROWAFTER for further help.

Craig
QREW Technologies

This Row Before and After

[Audit_CKGoC]

Thank you for the idea. But can you help to fix this?

[graham_howe]

It’s quite a small image there, but I think you have the following:

IF(
  TODAY() >= EOMONTH([date_for_payment], 6) +1,
  [_THISROW_BEFORE].[interest] + 2 = [_THISROW_AFTER].[interest],
  0
)

The problem with this expression is that it appears you are trying to assign a value within the IF statement, specifically the equals sign in this is wrong:
[_THISROW_BEFORE].[interest] + 2 = [_THISROW_AFTER].[interest]

Check the syntax for the if() function
https://help.appsheet.com/en/articles/2355953-if