Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Maintenance Revenue to exclude ......

From the code below my goal is to exclude "Grip" and "RH RECURE DATABASE SERVICE" from Maint_Revenue column   This is the slice of code that needs to be updated to  exclude Grip and RH RECURE DATA...
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous -

     

    Try this

     

    Maint_Revenue =
IF (
    NOT ( LEFT ( Contract_Items[QT Package], 4 ) = "Grip" ) &&
      NOT ( Contract_Items[QT Package] = "RH RECURE DATABASE SERVICE" ),
    Contract_Items[Price Monthly],
    0
)

     

    Hope this helps

    David 

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous -

 

Try this

 

Maint_Revenue =
IF (
    NOT ( LEFT ( Contract_Items[QT Package], 4 ) = "Grip" ) &&
      NOT ( Contract_Items[QT Package] = "RH RECURE DATABASE SERVICE" ),
    Contract_Items[Price Monthly],
    0
)

 

Hope this helps

David 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks David.  It was very helpful.