5 Replies Latest reply on Jul 10, 2018 10:59 AM by Deepak Rai

# Seeing the % increase in item cost per Orders

Hello,

I am trying to figure out the % difference between an ATTR(Item Cost) for each item associated with a Order and Order Line during a continuous date that Item was ordered.

For Example:

 Item # Order Date Order and order line Attr(Item Cost) 123 10/12/2017 321-1 \$0.64 321-2 \$0.64 1/31/2018 456-6 \$1.58 5/7/2018 789-4 \$2.35 789-11 \$2.35

So I would want to figure out how much was the % change of the cost of this item from the first transaction to the latest one for each and every Item.

From the first transaction of the item, cost was \$0.64 but the latest is now \$2.35 for the same item.

Any feedback on this will be helpful.

• ###### 1. Re: Seeing the % increase in item cost per Orders

Minimum value

{FIXED ITEM:SUM( IF{FIXED Item:MIN(Order Date)}=Order Date THEN Attr(Item Cost) END)}

Maximum Value

{FIXED ITEM:SUM( IF{FIXED Item:Max(Order Date)}=Order Date THEN Attr(Item Cost) END)}

% Change

((Maximum Value-Minimum Value)/(Minimum Value))*100

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to close Thread

• ###### 2. Re: Seeing the % increase in item cost per Orders

Are you referring to the "Item #"  or "Item Cost"

when you say {FIXED ITEM:SUM(IF{FIXED ITEM:MAX(Order DATE)}

"Item #" is a string BTW.

• ###### 3. Re: Seeing the % increase in item cost per Orders

Item #..No Problem if it is a String

• ###### 4. Re: Seeing the % increase in item cost per Orders

Ok I applied the calculations you provided but I'm getting something like this:

(Values are accurate)

 Item # Order Date Order and Lines ATTR(Item Cost) % Change 754 11/13/2017 478-6 \$0.65 0.00% 787 1/7/2016 158-10 \$0.64 8.12% 1/14/2016 541-29 \$0.69 8.12% 987 1/7/2016 521-5 \$0.64 815.04% 1/14/2016 245-9 \$0.69 815.04% 5/19/2017 354-7 \$0.64 815.04% 6/20/2017 523-4 \$0.64 815.04% 8/18/2017 366-8 \$0.64 815.04% 1/12/2018 721-1 * 815.04%

The 815.04% is high and not within 100% for that item.

There are more Item # with the same issue.

Also,

If I change the Item Cost to a Dimension then that * goes away and populates a value but the % Change remains the same.

Any thoughts?

• ###### 5. Re: Seeing the % increase in item cost per Orders

I need a workbook at this Point, If you can attach..so that you can be helped