Is there a way to assign a calculated field (or maybe a calculated item) to grouped data only?
In the attached file, I have a calculated field named Field 1. The formula is 90- 'Δ [min]'. Its calculation for the items Business Tax, GSH, and LSAT Prep are correct. Δ [min] is the header for how much time I've spent reading for that item. The goal is to read 90 minutes per week.
What I would want to do is count the number of items (in this case, the number is 3, namely: Business Tax, GSH, and LSAT Prep) and multiply that by 90. For those three items, the goal is to read a total of 270 minutes for the week. The calculated field takes the total Δ [min] and uses that value in the Field 1 formula, which is 90- 'Δ [min]'. How can that be changed? (See the Should be: column in the file for an example.)
Thank you!
Bookmarks