fmp17 How can I get the Penalty charge there beside the Balance?

[Tondats]

Hello guys, good evening.

Okay here's the story. When the Payment Date is exceeded on Due Date, there is a 10% penalty charge. But I got a problem here, I want to put a Penalty amount beside the Balance column. How can I get the Penalty charge there beside the Balance? (See the image below)

Thanks and God bless!

[Steve Martino]

Case(

   get(currentdate)>YourTable::DueDate field; YourTable::BalanceField * .1

)

But it seems like you are creating a separate record for a late charge.  This may actually be a better way IF in the following month you take the current balance, and apply 10% to that (like a credit card).