Being scratching my head on this one.
I've got two numeric fields FieldA and FieldB containing currency amounts and two date fields FieldAPaidDate and FieldBPaidDate
FieldA an FieldB are related but independent amounts which may be awarded and therefore paid out out on different dates.
Creating one view for what still requires paying and totalling it is easy enough by only diplaying FieldA/B in the column if their corresponding PaidDate has not yet been completed but what I need is a view as :
date (actually split into yyyy month etc. but that is OK). FieldAPaidDate:FieldBPaidDate multi-value categorised
Field A Field B Other fields
I would like Field A only to appear and therefore be totalled when the date in the categorised first column is the correct one.
I would prefer not to have two views, one each for FieldA and FieldB but need the totals to add up correctly as otherwise when both have been paid they will both show up two dates.
This is running on R5 at the moment.