Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Business Objects 6.5 Difficulties writing code

Status
Not open for further replies.

ashcon

IS-IT--Management
May 26, 2015
2
GB
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.

 
Select min([v_min Start Date])

Where [TAS] Not "Cancelled"
And [TTG] Not "Respond Billing
 
Thank you SkipVought....finally a helpful person, I will try the solution and feedback.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top