Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Subtract 1 from output

Hello All,   I have a measure as below:   OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))  This give me total row counts including column names.   I want to subtract 1 from the total count...
  • smpa01's avatar
    4 years ago

    sdhn  do you mean this

    OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))-1