how to get condition like this?

[Anonymous]

Hi all,

how to get for this condition,if the price of any item shows variation of 20% up or down from max product price.ie if price of the product is 400 if it increase to 440 or 360 the i want "product change".

thanks

arunreddy

[swuehl]

Where do you get your max product price from? I assume that you don't use the max price of a price history, since you can't get any price higher than this then. Is this a fixed value from a table?

Though I am not really clear about your setting, have you tried something like:

=if(Price < 0.8 * MaxPrice or Price >1.2 * MaxPrice, 'Product change')

[Anonymous]

thanks for reply swuehl.

i got the product price for diff item in that we consider only max price of that item.no it is not a fixed value.

my requirement is if the price of any item shows variation of 10% up or down from maxprice.then "product price changed"

>this price is to be compare with last reload time price.

thanks

arunreddy

[swuehl]

If you have a straight table chart with dimensions ItemNo and Date, this expression will indicate a change then:

=if( Price < 0.8*max(total<ItemNo> Price), 'Product Price Changed')

I omit the case 'Price higher than max', that should not be possible.

[qv_jagan]

Load the inline function and write the condition in text box and select each product.

LOAD * INLINE [
    Product, Price, Max_Price
    a, 50, 20
    b, 20, 30
    c, 30, 30
];

Condition:

=if(((Price-Max_Price)/Max_Price)>0.19 or ((Price-Max_Price)/Max_Price)<-0.19,'Product Change','No Change')

Regards,

Jagan V

[Anonymous]

Thanks for all,

here we need to send an alert message through mail if the abow condition is not satisify.

this i want to use in alert condition.

>every day when reload is done, the new price for perticular item is updated at that time we need to compare the price with last reload price.

>if it is abouw 10% then display product price change and send this message via mail.

thanks

arunreddy

[swuehl]

Well, that's a bit different from what you said before. You are not looking for max price but for last price, right?

You could work with something similar to an incremental load (i.e. just store the current Price to a qvd in your load, load the value in a variable on reload and compare in your alert with current price, similar to my first expression). Or, if you have prices with dates in table (history of prices), just compare two most recent prices.

[Anonymous]

Thanks for reply swuehl,

i will explain my scenario.

1.i have product price for particular item,in that the price of the item may change with diff dates.

2.the reload is done every day,if there is change in price more than 10% or below 10% compare with last price.

3.for that i want to send a alert mail the product price changed.

4.i need to declare the condition in alert wizard such that above condition satisfy and send the alert message to recipient

Thanks

arun reddy