Forum

Sum by Max(Expiry Y...
 
Notifications
Clear all

Sum by Max(Expiry Year)

3 Posts
2 Users
0 Reactions
73 Views
(@alib40)
Posts: 113
Estimable Member
Topic starter
 

See attached file

I have a row for each year of a contract.   I need to create a table that includes only the final year of the contract data ie when it truly expires to enable the calculation to give Total Contracts expiring in a given year

 

How can I do this?

 
Posted : 14/01/2019 11:26 am
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

Hi,

Something like this?

 
Posted : 17/01/2019 2:10 am
(@alib40)
Posts: 113
Estimable Member
Topic starter
 

Yes.  Thanks. But I can't see how you have calculated it?

 
Posted : 19/01/2019 7:17 pm
Share: