i have a question, i've created the master calendar and whithin my master calendar i used this structure to create two flags for current and last year:
inyeartodate (TempDate, $(vToday),0) * -1 as CurYTDFlag ---------- for Current Year
inyeartodate (TempDate, $(vToday),-1) * -1 as LastYTDFlag ----------for Last Year
the Flag for Current Year does work great, but the flag for last year does not show any numbers ( like 1 and 0), although it does look correct.
Does anybody have any idea?
Thanks a lot