9 Replies Latest reply: Sep 16, 2015 3:19 AM by Kalyan Navuluri

# Set analysis

Hi,

i Know set analysis.but i want to how to use ytd,mtd,lytd,mytd, and where to use any particular senario for using this

i would be  grate if u attach any qvd related to this .

• ###### Re: Set analysis

We have similar work we do. This is how we do mtd and ytd. Our financial year is July to June. There are probably easier ways to do this, but maybe this helps

MTD

if(Month='Jul',sum(BudgetJul),

if(Month='Aug',sum(BudgetAug),

if(Month='Sep',sum(BudgetSept),

if(Month='Oct',sum(BudgetOct),

if(Month='Nov',sum(BudgetNov),

if(Month='Dec',sum(BudgetDec),

if(Month='Jan',sum(BudgetJan),

if(Month='Feb',sum(BudgetFeb),

if(Month='Mar',sum(BudgetMar),

if(Month='Apr',sum(BudgetApr),

if(Month='May',sum(BudgetMy),

if(Month='Jun',sum(BudgetJun),

))))))))))))

YTD

if(Month='Jul',sum(BudgetJul),

if(Month='Aug',sum(BudgetJul+BudgetAug),

if(Month='Sep',sum(BudgetJul+BudgetAug+BudgetSept),

if(Month='Oct',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct),

if(Month='Nov',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov),

if(Month='Dec',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec),

if(Month='Jan',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan),

if(Month='Feb',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb),

if(Month='Mar',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar),

if(Month='Apr',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr),

if(Month='May',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMy),

if(Month='Jun',sum(BudgetJul+BudgetAug+BudgetSept+BudgetOct+BudgetNov+BudgetDec+BudgetJan+BudgetFeb+BudgetMar+BudgetApr+BudgetMay+BudgetJun),

))))))))))))

• ###### Re: Set analysis

Could any one attach related qvd for this example

• ###### Re: Set analysis

PFA

• ###### Re: Set analysis

thanku kN

is it same steps we will follow for  lytd,mytd,qtd

• ###### Re: Set analysis

Yes absolutely,

See the above links given by other members if you find any difficulty

• ###### Re: Set analysis

Have a look at this