topic Re: DTD, MTD, YTD Calculation in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/DTD-MTD-YTD-Calculation/m-p/178549#M1206 <HTML><HEAD></HEAD><BODY><P>Dear avinesh,</P><P>One of the options is to create a new calculated field that results in YTD. You can use this new value for reporting.</P><P>Example YTD:</P><P><IMG alt="YTD.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/5983_YTD.png" width="450" /></P><P>The New calculated item YTD will only be filled if the DayOfYear is less/equal of actual DayOfYear</P><P><IMG alt="YTD_R.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/5984_YTD_R.png" width="450" /></P><P>Of course it all depends on the way you want to show your results and how your definitions of YTD etc. exactly are.</P><P></P><P>For MTD you can add that also the months are equal.&nbsp; etc.ect.</P><P></P><P>Greetings and good luck.</P></BODY></HTML> Tue, 15 Apr 2014 05:49:53 GMT PeterWijers 2014-04-15T05:49:53Z DTD, MTD, YTD Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/DTD-MTD-YTD-Calculation/m-p/178548#M1205 <HTML><HEAD></HEAD><BODY><P>How to calculate DTD, MTD, YTD calculation in a single section of VA 6.4?</P></BODY></HTML> Mon, 14 Apr 2014 08:59:22 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/DTD-MTD-YTD-Calculation/m-p/178548#M1205 avinesh 2014-04-14T08:59:22Z Re: DTD, MTD, YTD Calculation https://communities.sas.com/t5/SAS-Visual-Analytics/DTD-MTD-YTD-Calculation/m-p/178549#M1206 <HTML><HEAD></HEAD><BODY><P>Dear avinesh,</P><P>One of the options is to create a new calculated field that results in YTD. You can use this new value for reporting.</P><P>Example YTD:</P><P><IMG alt="YTD.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/5983_YTD.png" width="450" /></P><P>The New calculated item YTD will only be filled if the DayOfYear is less/equal of actual DayOfYear</P><P><IMG alt="YTD_R.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/5984_YTD_R.png" width="450" /></P><P>Of course it all depends on the way you want to show your results and how your definitions of YTD etc. exactly are.</P><P></P><P>For MTD you can add that also the months are equal.&nbsp; etc.ect.</P><P></P><P>Greetings and good luck.</P></BODY></HTML> Tue, 15 Apr 2014 05:49:53 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/DTD-MTD-YTD-Calculation/m-p/178549#M1206 PeterWijers 2014-04-15T05:49:53Z