Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this
Count({$<[ Date.autoCalendar.InYTD] = {1}, [Date.autoCalendar.YearsAgo] = {0}, [Days Remaining] = {"<0"}>} [Title ])
How about this
Count({$<[ Date.autoCalendar.InYTD] = {1}, [Date.autoCalendar.YearsAgo] = {0}, [Days Remaining] = {"<0"}>} [Title ])
Hey,
why do you want to use the if statement here?
You can just add another condition to the calculation:
It works Sunny ! Thank you so much.