need help on alerts condition

[vishalgoud]

Hi Community,

I need a help on alerts condition..here is my problem.

i have three fields

1.ticket no(two types like "1234567" and "638738")

2.ticket actual effort hours

3.ticket approved hours.

now my requirement is to display alert where the ticket no starting with "12 "and if any ticket's effort hours are greater than of 85% of approved hours.

Thanks in Advance.

[sunny_talwar]

Is this alert going to be in a text box or straight table???

Best,

Sunny

[vishalgoud]

smal clarification condition is for any ticket starting with "12" and actual effort hours greater than 85% of approved hours

[vishalgoud]

i want a pop-up msg for the document

[sunny_talwar]

I am thinking you can color code it using nested if:

=If(ticket_no = '1234567', If(ticket_actual_hours * 0.85 > ticket_approved_hours, yourAlert, yourNoAlert))

this statement can be used to define colors also.

HTH

Best,

Sunny

[avinashelite]

to create alert you need to add one more column named as alert and try the expression like this.

if(wildmatch(ticket_no,'12*')>=1 and (sum(actual_efforts)/sum(approved_hours))>0.85, ticket_no)

[vishalgoud]

is this condition works in alert condition?

[sunny_talwar]

Can you share a sample application so that we can work on your exact output.

Best,

Sunny

[avinashelite]

try as below:

if(wildmatch(ticket_no,'12*')>=1 and (sum(actual_efforts)/sum(approved_hours))>0.85, ticket_no)

this should do

[vishalgoud]

Hi Avinash i need to write condition in alert condition

i.e in tools-->alerts