Skip to Content
avatar image
Former Member

Order Contains Backorder

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded