Aggr Function With IF Statement

[dineshm030]

Hi All,

I am facing the issue while use AGGR function with IF statement. While using the IF statement FALSE condition is not showing. Am using below expression:

=Aggr(If(Max({<SCADA_DateTimeEST = {'$(=Max(SCADA_DateTimeEST))'}>}SCADA_FAULT_NUMBER) >= 0 ,[Machine Fault Condition],'No Demand'),[Machine Fault Condition])

Thanks in advance.

Regards,

Dinesh Kumar Mani.

[Kushal_Chawda]

@dineshm030  you need to define false condition in else part of the if statement

=Aggr(If(Max({<SCADA_DateTimeEST = {'$(=Max(SCADA_DateTimeEST))'}>}SCADA_FAULT_NUMBER) >= 0 ,[Machine Fault Condition],'Not matched'),[Machine Fault Condition])

[dineshm030]

Now True condition is not working.

[Kushal_Chawda]

@dineshm030  without looking at your data and condition it is hard to tell where it is wrong. Please share sample data with expected output