conditional Set analysis

[markgraham123]

Hi Everyone,

I'm fetching count(Distinct(Awards) if name='John'.   count({$<Name={'John'}>} DISTINCT Awards)

I wanna restrict the year to 2015.

Can someone throw some limelight.

[sinanozdemir]

Try something like this:

count({$<Name={'John'}, Year = {2015}>} DISTINCT Awards)

[Kushal_Chawda]

try,

count({$<Name={'John'}, Year ={"$(=max(Year))"}>} DISTINCT Awards)

[markgraham123]

Thanq Sinan.

[markgraham123]

Thanq Kush.

both of the solutions worked

[markgraham123]

Hi,

I wanna calculate the below expression using set analysis for year 2015 like

(Sum([Units])/Count(Distinct([route Number])))

If (Year=2015, (Sum([Units])/Count(Distinct([routeNumber]))))

Can you help me in the syntax pls.

[Kushal_Chawda · Accepted solution]

Try this

Sum({<Year ={"$(=max(Year))"}>}[Units])/Count(Distinct{<Year ={"$(=max(Year))"}>}[routeNumber])

[markgraham123]

Thanq Kush.

[sasiparupudi1]

Sum({<Year={2015}>}[Units])/Count({<Year={2015}>}Distinct([route Number]))

[Kushal_Chawda]

Welcome Mark