Budget Amendment Formula
I need some help with a currency formula. I have Grant Award Amount currency field which is input as a grant comes in. Sometimes we have amendments to a grant, either adding or subtracting money, so I...
Forum Discussion
I do a similar thing with Projects, and modifications for the project. If you will only have a max of one amendment, you could probably get away with not having an Amendments table. Otherwise, if it's an unknown number, I would make an amendments table. I'm a fan of the child table because you inevitably want to add more info with the amendment (date, title, a file, etc). That table has the amendment amount (plus whatever other fields).
Grant Award has Many Amendments.
Summary field on grant award of the total amount in Amendments.
Grant Table you have Initial amount field, and now the Amendment Total Summary Field. Create numeric formula field on Grant Table 'Grant Total With Amendments'. ([Amendment Total Summary Field] + [Grant Initial Amount].
In this scenario they technically enter into your Amendments table, but its a seamless user experience. They simply click 'Add Amendment', enter the price, and save.
------------------------------
Mike Tamoush
------------------------------
Grant Award has Many Amendments.
Summary field on grant award of the total amount in Amendments.
Grant Table you have Initial amount field, and now the Amendment Total Summary Field. Create numeric formula field on Grant Table 'Grant Total With Amendments'. ([Amendment Total Summary Field] + [Grant Initial Amount].
In this scenario they technically enter into your Amendments table, but its a seamless user experience. They simply click 'Add Amendment', enter the price, and save.
------------------------------
Mike Tamoush
------------------------------
- Perfect! Thanks!!
------------------------------
Bethany Hudson
Program Administrator
Mobile Bay National Estuary Program
Mobile AL
2514598870
------------------------------