Forum Discussion
POSPOS
Post Partisan
Post PartisanHow to show outliers with multiple date fields
Hi all, I have a requirement to know the outliers for orders i.e, how may days a order has taken for submission, for firstreview, for final review, for activation. We would like to use a scat...
gadielsolis
Resolver III
Resolver IIIWhat about final? Should be blank or the days between final and intake?
POSPOSPost Partisan
Post Partisangadielsolis -
These are the 4 steps to be represented. We do not have a step which has to show days between final and intake.
days for submission -- Days between intake and submit
days for first review-- Days between submit and review
days for final review-- days between review and final
days for activation -- days between final and processed
If you were referring to final and processed , then yes, the values should be the difference between the two dates and should not be blank.
Irrespective of whether the previous step has a date or does not have a date, the current step should still be the days between the steps based on the formula.