1 Reply Latest reply: Nov 5, 2012 11:05 AM by tmendesf RSS

    alert message with condition

      Hi,

      I have a trouble with creating a condition in the message for alert firing.

       

      I have data:

      report name          alert ind

      A                         ALERT

      B                         -

       

      I set the alert so that whenever there is ALER in the alert_ind it should fire. And it does, however I would like to have the message "report A needs to be refreshed".

       

      I tried to use ='report ' & if(alert_ind = 'ALERT', [report name]) & 'needs to be refreshed' however this message pops up without A inside..

      Can you please help?

      Thanks a lot.

      J,