Solved

Insert a calculated Field between "  "

Posted on 2011-02-25
6
401 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
  • 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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 500 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now