Calculating YTD Numbers

[nvrphanikumar]

Hi,

Fairly New

Trying to calculate YTD Filled numbers.

At first tried this

COUNT({$<[Current Disposition Status]={'090 Hired'},year([Filled Date]) = {'$(=Year(Today()))'}>} [Application ID])

and learnt that i cant use Functions on the left side.

Tried this

Count(if(Year([Filled Date]) = {$(=Year(Today()))}), [Application ID]))

Still cant get the right values,Can someone please correct where i'm wrong?

[MK_QSL]

Create FilledYear in script as below

Year([Filled Date]) as FilledYear

Count({<[Current Disposition Status]={'090 Hired'}, FilledYear = {'$(=Year(Today()))'} >}[Application ID])

[nvrphanikumar]

There are many Metrics for which i need to calculate YTD, Is there a better way than creating the Year Column in the dataset ?

[MK_QSL]

Provide source data or sample application. Can suggest you something only after checking that..