Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to get the sum(records) and i'm using below expression, but it doesn't give any value
=sum({$<nw_CAL_RULE_TIME={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"}>}
if((CAL_RULE_TIME-RULE_ICR)*24 < 80 , if(Len(Trim("RULE_RBL")) = 0 and Len(Trim("RULE_RLO")) = 0 and Len(Trim("RULE_RMT")) = 0,
if(Len(Trim("Rule_HIS_BAD")) = 0,if(Len(Trim("HOLD_DTM")) = 0 and Len(Trim("TO_ROADMARK")) > 0,
count(RULE_ICH))))))
please correct me