I have a requirement. There is a project date and shipment date in two columns in the report.
Now user wants a third column based on the two(Project & Shipment date)
Like : 1) if project date is greator than shipment date then the third new column value should be ' Early'.
2) if Project date is less than shipment date then the third new column value should be 'Late'.
3) if the Project date is equal to shipment date then the third column value should be 'on time'.
1) Pro date ship date Third cloumn
9/12/2014 7/12/2014 EARLY
The third column value is actually a text.
Iam checking If else statements but I don't think it will work for me.
Please suggest if we can achieve this by the Bex formulas.