


Re: Set analysis
Andre Toerien Sep 16, 2015 3:05 AM (in response to abc a)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
abc a Sep 16, 2015 3:11 AM (in response to abc a)Could any one attach related qvd for this example


Re: Set analysis
abc a Sep 16, 2015 3:17 AM (in response to Kalyan Navuluri)thanku kN
is it same steps we will follow for lytd,mytd,qtd

Re: Set analysis
Kalyan Navuluri Sep 16, 2015 3:19 AM (in response to abc a)Yes absolutely,
See the above links given by other members if you find any difficulty



Re: Set analysis
Gowtham Kesavan Sep 16, 2015 3:16 AM (in response to abc a)Have a look at this

Test.qvw 150.2 K

