问题描述
您好，
我尝试了各种各样的方式，无法通过这个方式。
[设施]将[每周]报告[#inches ]。这仅用于跟踪测量。我希望仅根据报告月份的[上次报告日期]获得所有设施的#inches总和。
基于每个[设施的[上次报告日期] ]，总和[#inches]
因此，设施A报告为1-3-14（5英寸），1-9-14（10英寸），1-15-14 （40英寸），1-21-14（2英寸）
1-21-14 = 2英寸设施A
1-15- 14 = 17英寸的设施B（以上为例）
...仅使用2作为示例
总和= 1英寸19英寸/>
我尝试将Max与没有赢家合并。
谢谢
Hello,
I have tried various ways and cannot get through this one.
A [facility] will report [weekly] their [#inches]; this is for tracking measurements only. I am looking to get the sum of #inches for all facilities based only on the [last reported date] of the reported month.
Based on [last reported date] of each [facility] , sum [#inches]
So, facility A reported on 1-3-14 (5 inches), 1-9-14 (10 inches), 1-15-14 (40 inches), and 1-21-14 (2 inches)
1-21-14 = 2 inches for Facility A
1-15-14 = 17 inches for Facility B (following ex above)
...just using 2 for the example
Total Sum = 19 inches for January
I tried incorporating Max with no winners.
Thank you
推荐答案
这篇关于报告：文本框按报告的上次日期对设施的#inches求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！