I have recently started using BO as part of my responsibilities at work.
I am trying to create a report and assign an overall date based on 2 variables( TTG and TAS). The IF/Where statements I have written seem to be missing something as i keep getting an error.
The results should be such that:
-If the TAS is "Cancelled", do not assign that entry's v_min start date as overall date.
-If the TTG is "Respond Billing" do not assign that entry's v_min start date as the overall date.
Otherwise assign the minimum/oldest date value of the remaining entries as the overall date.
I have asked this question on BOB and there doesn't seem to be anyone who can figure it out, I am hoping someone out there knows how I can go about this. Here is a sample of the data:
Entry TAS TTG v_Min Start Date
A , Cancelled , Incomplete, 18/10/2013
B , Inactive , Incomplete , 29/12/2014
C , Inactive , Installation , 25/02/2014
D , Inactive , Installation , 17/10/2014
E , Cancelled , Installation , 19/02/2015
F , Inactive , Investigation , 11/12/2013
G , Inactive , Investigation , 09/01/2015
H , Inactive , Investigation , 05/02/2015
I , Inactive , Respond Billing , 08/12/2013
The Overall Date(Result)for this data set is 11/12/2013.
Any help is appreciated.
I am trying to create a report and assign an overall date based on 2 variables( TTG and TAS). The IF/Where statements I have written seem to be missing something as i keep getting an error.
The results should be such that:
-If the TAS is "Cancelled", do not assign that entry's v_min start date as overall date.
-If the TTG is "Respond Billing" do not assign that entry's v_min start date as the overall date.
Otherwise assign the minimum/oldest date value of the remaining entries as the overall date.
I have asked this question on BOB and there doesn't seem to be anyone who can figure it out, I am hoping someone out there knows how I can go about this. Here is a sample of the data:
Entry TAS TTG v_Min Start Date
A , Cancelled , Incomplete, 18/10/2013
B , Inactive , Incomplete , 29/12/2014
C , Inactive , Installation , 25/02/2014
D , Inactive , Installation , 17/10/2014
E , Cancelled , Installation , 19/02/2015
F , Inactive , Investigation , 11/12/2013
G , Inactive , Investigation , 09/01/2015
H , Inactive , Investigation , 05/02/2015
I , Inactive , Respond Billing , 08/12/2013
The Overall Date(Result)for this data set is 11/12/2013.
Any help is appreciated.