alert message with condition

[#1]

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,

[#2]

Hi

Try to put only([report name])

TMF