3 Replies Latest reply on May 6, 2018 6:57 AM by Jennifer VonHagel

# LOD Calculation

Hello,

I like to created two fields Sales and Profit the conditions would be if marketing is equal to zero then I want Operations value in Sales column and if marketing is not equal to zero then I want Operations value in Profit column.

And their is another condition which I am facing problem is when there are multiple lines for Order Id's for example when Order ID -  100D has marketing values zero and 1250 ( WITH SAME PART NUMBERS) then I want operations values 660 and 2385 in Sales Column instead of 660 in Profit column.

If it is a unique part number then 660 in Profit column is good.

I attached my workbook.

Final result would be like this

• ###### 1. Re: LOD Calculation

Hi,

I created a calculation to count the number of times a part shows up in the same order:

[Parts x per Order]: { FIXED [Order ID], [Part Number] : COUNTD([Line ID]) }

[Sales]: IF [Part x per Order] > 1 OR [Marketing] <> 0 THEN [Operations] ELSE 0 END

[Profit]: IF [Part x per Order] = 1 AND [Marketing] = 0 THEN [Operations] ELSE 0 END

Does this look right?

best,

Jennifer

1 of 1 people found this helpful
• ###### 2. Re: LOD Calculation

Thank you Jennifer, this works perfect!!!!

• ###### 3. Re: LOD Calculation

You're welcome!