Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to calculate YTD using DayNumberOfYear(). My calendar is FY, first month is Oct. In MasterCalendar I have added DayNumberOfYear(DateofSale,10) as DayNbrOfYear now in the set analysis I am trying to check a range if day falls between day 1 and the day number as of Today(). Problem is it is not giving me syntax error and not calculating it properly. For e.g as of today it should add up only day 1-142 it is adding up entire Year.
sum({$<DayNbrOfYear={">=1<=({DayNumberOfYear(today(),10)})"}>} Qty)
Please help. I am new to QV and have not much experience with Set Analysis.
Thanks
Rashid
Try
sum({$<DayNbrOfYear={"<=$(=DayNumberOfYear(today(),10))"}>} Qty)
HIC
Try
sum({$<DayNbrOfYear={"<=$(=DayNumberOfYear(today(),10))"}>} Qty)
HIC
Thanks Henric! You are the Best