Skip to Content
0

Order Contains Backorder

Oct 18, 2017 at 03:52 PM

11

avatar image
Former Member

Hi, for each order number field, i have an order line status field that indicates if each product is in stock or on a backorder. I want to be able to write a measure that indicates whether the whole order contains a backorder or not.

Example below. I'd like they greyed out line to say contains backorder for each unique order

twco3.png (3.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 18, 2017 at 04:13 PM
0

Hi David,

Please create new variable =if ([order line status]="Backorder";1;0)

Let me know if its solved your problem or not.

Regards,

Anish

Share
10 |10000 characters needed characters left characters exceeded