2 Replies Latest reply: Jan 23, 2018 9:54 AM by Neena Bhattarai

# Trying to create an expression in a pivot table.

I currently have 4 Shipping periods: 0-24 hours, 24-48 hours, 48-72 hours, and 72+hours. I want to focus on the 72+. Some orders are usually done way ahead of shipment. So that means they are put under the 72+ hours category but technically they are not carryover orders and don't need to be labeled as orders that haven't been shipped yet. How can I distinguish the difference between these orders and orders that are actually "delayed" or "late" for shipment? I have a Ship By Date field that tells me when the order is supposed to go out. But how do I go about this? The CarryOver Dimension is currently calculated like this

=if([CarryOver Days]<1,'0-24 hours',

if([CarryOver Days]=1,'24-48 hours',

if([CarryOver Days]=2,'48-72 hours',

if([CarryOver Days]>2,'72+ hours'))))

The Ship by date is an actual date field. If an order has a Ship By Date that means it technically is not a CarryOver order. This will help the mangers in the warehouse to see what is truly is a delayed shipment and what orders does not need to be shipped out till a later date.

• ###### Re: Trying to create an expression in a pivot table.

May be this if not please proved a few more details .

i am assuming [Ship By Date] as the field name

=if(len(trim([Ship By Date]))=0,'delayed', if([CarryOver Days]<1,'0-24 hours',

if([CarryOver Days]=1,'24-48 hours',

if([CarryOver Days]=2,'48-72 hours',

if([CarryOver Days]>2,'72+ hours')))))

• ###### Re: Trying to create an expression in a pivot table.

Thank You! That worked!