How to combine IF condition and set analysis ?

[claudialet]

    Here is my condition: 

=count (if([Days Remaining] <0, [Title ]))

Here is my set analysis:  

count ({$< [ Date.autoCalendar.InYTD]={1} ,[Date.autoCalendar.YearsAgo]={0}> } [Title ] )

If I try this :

count (if([Days Remaining] <0, 

({$< [ Date.autoCalendar.InYTD]={1} ,[Date.autoCalendar.YearsAgo]={0}> } [Title ])) 

This doesn't seem to work . It  returns a  '-'   in the kpi object

[sunny_talwar · Accepted solution]

How about this

Count({$<[ Date.autoCalendar.InYTD] = {1}, [Date.autoCalendar.YearsAgo] = {0}, [Days Remaining] = {"<0"}>} [Title ])

[y_grynechko]

Hey,

why do you want to use the if statement here? 

You can just add another condition to the calculation:

[claudialet]

 It works Sunny ! Thank you so much.