YTD consumed days

[joshrussin]

I am trying to get the value of Year to Date consumed work days, with holidays into a table.

Count({$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1

This formula works in a text box, but returns a 0 within the table. Any ideas?

**The correct return should be 160 days consumed

[sunny_talwar]

What value do you expect to see for this in the table?

[joshrussin]

160

[sunny_talwar · Accepted solution]

This gives 160

Count(TOTAL {$<Year_BV = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,(vHolidaysBV))))"}>}

distinct [Date Bioventus]) -1