YTD

[bharatkishore]

HI All,

I am calculating to get ytd logic but some how it is going wrong.

Can you please help me where i am doing wrong.

Attached app for reference.

Thanks,

Bharat

[YoussefBelloum]

Hi,

are you trying to get the YTD value manually, I mean with the Yearmonth listbox ?

because I don't see a YTD expression in your table

[Anonymous]

I found this worked for me when I was trying to work out my year to date:

Let vCMonth = Num(Month(Today()));

TRACE *** vCMonth $(vCMonth);

if(Num(month([$(_field)]))<=$(vCMonth),1,0) as [$(_prefix)YearToDateFlag]

Then use the year to date flag in your set analysis