?
Solved

Insert a calculated Field between "  "

Posted on 2011-02-25
6
Medium Priority
?
415 Views
Last Modified: 2012-05-11
Hi
I need have a calculated field inserted to form part of the result of the text .
IE.I need to have the result read..."Contract Due to expire in 4 (Days left before Contract Expires)Days"
The example below not giving me this .The Function works without the GeatasText(Days..etc
Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date );"";
Days Left before contract Expires<10;"Contract Due to Expire in;(GetasText(Days Left before contract Expires))";
)
Thanks
0
Comment
Question by:Krisraychris
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:North2Alaska
ID: 34981162
Try this:
Let (
  [
    ~NumDays = Get ( CurrentDate ) - ( Get ( CurrentDate ) - 4 ) ;   // Replace with Contract end Date
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (
    // IsEmpty ( Contract end Date ) ; ""
    ~NumDays < 10 ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
    ""
  )
)

It will produce:  Contract Due to Expire in 4 Days
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 34981186
I forgot to mention to change ( Get ( CurrentDate ) - 4 ) to Contract end Date and to remove the // in the case statement.
0
 

Author Comment

by:Krisraychris
ID: 35004415
Thanks for your reply.
I have made some changes to your idea and it looks ok for now.I woudl be pleased to know if you think this is ok.

Case(  Contract end Date-Get(CurrentDate)>=0;Contract end Date-Get(CurrentDate);Contract end Date-Get(CurrentDate)<0;"")

Let (
  [
    ~NumDays =    Days Left before contract Expires;    
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date )
      ; "";
    (~NumDays < 10)  and (~NumDays >1) ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
   
   ~NumDays >=10 ; "Contract Active" ;~NumDays =0 ; "Contract Expired " ;""))
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Krisraychris
ID: 35004432
DaysLeftBeforeContractExpires :
Case(  Contract end Date-Get(CurrentDate)>=0;Contract end Date-Get(CurrentDate);Contract end Date-Get(CurrentDate)<0;"")

AlertToRenew:Let (
  [
    ~NumDays =    Days Left before contract Expires;    
    ~Unit = If ( ~NumDays = 0 or ~NumDays > 1 ; " Days" ; " Day" )
  ];
  Case (IsEmpty ( Contract Start  Date )or IsEmpty ( Contract end Date )
      ; "";
    (~NumDays < 10)  and (~NumDays >1) ; "Contract Due to Expire in " & ~NumDays & ~Unit ;
   
   ~NumDays >=10 ; "Contract Active" ;~NumDays =0 ; "Contract Expired " ;""))
0
 
LVL 12

Accepted Solution

by:
North2Alaska earned 2000 total points
ID: 35005841
Looks good.  The only thing you might consider is the condition for "Contract Expired".  You may want to change "~NumDays =0" to "~NumDays <= 0".  The thinking is once the  number of days until the contract expires goes to zero or negative it should always read "Contract Expired " 
0
 

Author Comment

by:Krisraychris
ID: 35006292
Perfect...Thank you.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question