Need Help...........

[paulwalker]

Hi Community,

I have OrderQty and Schedule Qty..

OrderQty should be less than ScheduleQty....

then i want to show alert..

please anyone can help me......

Thanks in Advance..........

[Anonymous]

1. DECLARE TWO VARIABLE GLOBALLY (SETTING ->DOCUMENT PROPERTIES->VARAIBLE)

   VARIABLE1 = SUM(Order Qty)

    VARIABLE2 =SUM(Sch Qty)

2.  NOW GO TO TOOLS -> ALERTS

3. CLICK ADD BUTTON

4. IN CONDITION BOX TYPE   =Variable1>Variable2

5   type OrderQty  is greator   in message box !!.

6. press  OK.

when you reload alert box will come.

note in your excel data the order quantity is less then sch quantity so alert will not come for year 2013 and month 12

untill if you really want to see alert box the either change and add value or let it automatically happen.

regards,

anant

[ljackson]

Is this what you mean?

[ljackson]

I created a chart, then included an 'if' expression to see if the order qty was less than the scheduled order.  It creates a new column, but will only show an 'alert' on the relevant line.

.

[Peter_Cammaert]

Or this one. Check background color expression of Sch Qty column. No extra columns needed.

Luck,

Peter

[ljackson]

Ahh yes, I prefer your reply to mine!

.

[stevedark]

Hi Paul,

This seems to be the same question you asked in another thread?

If both fields exist on one row of the source data the best bet is to add a new calculated field in the load script:

UnitPrice,

Cost,

If(UnitPrice > Cost, 1, 0) as AlertCount,

If(UnitPrice > Cost, 'Yes', 'No') as Alert,

You can then have a text box with the following expression to show the number of Alerts:

=sum(AlertCount)

You could then have an Action on here to select Yes in the Alert field. You could also show Alert as a simple Yes/No List Box.

How that helps,

Steve