Forum Discussion

sdhn's avatar
sdhn
Responsive 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 counts. Above query subtract -1.
 
any help will be appreciated.
 thanks 
 
 
 
 
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    sdhn  do you mean this

    OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))-1

1 Reply

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    sdhn  do you mean this

    OpenNMSCounts = COUNTROWS(ALLSELECTED(ONMSAlerts))-1