3 Replies Latest reply on Apr 15, 2016 4:02 AM by Devendra Sahu

Need Calculations of MTD,Full Month,YTD & Full Year for particular measure

Hello All,

I need to calculate MTD,Full Month,YTD & Full Year for particular measure.

For MTD and YTD  Please find the below calculation which i Implemented.

MTD:

if YEAR([FISCAL_DATE]) = YEAR(TODAY())

and MONTH([FISCAL_DATE]) = MONTH(TODAY())

then ([LOCAL_SALES])

END

YTD:

if year([FISCAL_DATE])=year(TODAY()) then [LOCAL_SALES]

END

Similarly i need to calculate the same for Full Month and Full Year.

Regards,

Koushik.

• 1. Re: Need Calculations of MTD,Full Month,YTD & Full Year for particular measure

Hello Koushik,

From your calculations, I can say they should work but in the absence of direction and a workbook, I cannot provide help.

Please can you provide more detail on what it is you are trying to do and provide a sample workbook so we can get better eyes on.

Thank-you

Steve

• 2. Re: Need Calculations of MTD,Full Month,YTD & Full Year for particular measure

Your MTD calc is also Full Month (of current month) and your YTD calc is also Full Year (of current year). Can you please elaborate what you're trying to do?

• 3. Re: Need Calculations of MTD,Full Month,YTD & Full Year for particular measure

If I have understood it clearly then you have to use LOD expression for these calculations.

Full Month:

{ include MONTH([FISCAL_DATE]) : SUM([LOCAL_SALES]) }

Full Year:

{ include YEAR([FISCAL_DATE]) : SUM([LOCAL_SALES]) }

If you want Average then replace SUM with AVG

If this is not the case then elaborate your problem with sample data.