Clarification on the query

[ishanbansal1204]

Hi Experts ,

I have a query which should fetch results based on certain condition for the given year.

IF(STATUS = 'Closed',COUNT(DISTINCT{<YR={'$(=max(YR))'}>}ID))

But this query is not fetching any result. can you please help me fix the query.

Thanks

[jonathandienst · Accepted solution]

Is STATUS a field? Are you performing this in a table with dimensions or in a dimensionless context (like a text box)?

If there is more than one possible value for STATUS, it will be evaluated as null. Perhaps you need

COUNT({<STATUS = {'Closed'}, YR={'$(=max(YR))'}>} DISTINCT ID))

[poojashribanger]

Hi,

please use double quote

IF(Division ='TELECOM',

COUNT(DISTINCT{<Year={"$(=max(Year))"}>}IBG))

[ishanbansal1204]

Thank you Jonathan.

[ishanbansal1204]

Thank you Poojashri