问题描述
大家好，
问题在于我有一个excel表中的数据，我在Access中链接。它是一个Pharma数据，我必须计算一些公司的YTD销售额。
它是一个37个月的数据和月份分类为M1，M2 .... M37，其中M37是最近一个月。所以ytd的计算结果看起来像是m $，mtd为m1，Ytd为m2，Ytd为m3 ....直到M12，Ytd为m13
m1 m1 + m2 m1 + m2 + m3 m13 ..
新的一年从M13开始，它将从第一个点恢复到M25时再次恢复如果你认为M1是1月再次从M37开始
我可以使用正常金额在MsAccess中对这些公式进行硬编码，但因为它始终是37个月的数据而且这些月份继续前进M1从1月到2月变化，所以整个编码都失败了。
任何人都可以帮我这么做真的很重要
如果你需要，请还原关于我的更多解释
Hi everyone ,
I have an urgent report to make in Ms Access and consider me a beginner.
The problem is that I have data in an excel sheet which i have linked in the Access.It is a Pharma data and I have to calculate YTD sales for some Companies.
Its a 37months data and the months are categorized as M1,M2....M37 where M37 is the latest month. so the calulation for ytd would look like as
Ytd for m1, Ytd for m2, Ytd for m3 .... till M12 ,Ytd for m13
m1 m1+m2 m1+m2+m3 m13..
and as the new year starts with M13 it will again resume from the first point when it reaches M25 and would again start from M37 if you consider M1 to be January
I could have hard coded this formulae in MsAccess using normal sum but as it is always a 37 months data and the months move ahead and M1 changes from January to feburary and so the whole coding fails.
Can anyone help me to do this Its really important
Please revert if if you need any more explanation on my part
推荐答案
这篇关于计算年初至今的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！