countif

[samuel_brierley]

Hi First I want to say thank you for all the help people are on this site,

can somebody explain where im going wrong in this expression?

if( [Fault Status]={HARD} count( [Fault Detected]) - count ({$< [Fault Cleared] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] )

the 2 count expressions work fine its the if statement that is an issue, or maybe how im combining the two,

its supposed to say if Fault status = HARD do the following expression

[christophebrault]

I supose you want to do this :

if( [Fault Status]='HARD', count( [Fault Detected]) - count ({$< [Date Detected] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] ))

[swuehl]

Fault Status must have an unambiguous value in the scope of the expression to work (like Fault Status as dimension for the expression), then just try

if( [Fault Status]='HARD' ,

     count( [Fault Detected] ) - count ({$< [Fault Cleared] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] )

)