On the attached, you will see I have two lines that intersecting on a graph.
I need help changing the calculation on the License & ME&S Month 1 measure. Instead of adding the License value + ME&S value together, I need to break the ME&S value, which is an annualized value, into a monthly value. Meaning each month, I need to add 1/12 of the ME&S value to the License value.
So the first month would be the full License value and 1/12 of the ME&S value. The second month would be only 1/12 the ME&S value, and so on.
Any and all help is much appreciated! Thanks!
I'm not 100% sure I follow, but if you want the first month to be the full license plus 1/12 of the ME&S value then all remaining months to be just 1/12 of the ME&S value, then just set your calculation as follows:
License & ME&S
IF [Month]=1 THEN [License] + [Me&S]/12
ELSE [Me&S]/12
END
I have a feeling that this is not exactly what you were looking for. If it is not, could you expound upon your example and perhaps give a few specific numbers that you'd like for it to result in?
Thanks! 😃
Kevin Flerlage
