New Ticket Existing and Public Tickets   
Ticket:  388  Created: 11/17/2014 12:00 AM
 
Public/Private:
Status:    Assigned:      
Lean Application / Version:
Priority:       Due Date:  
Name:   Invesco Houston USA    
Email:   -
Phone:    Estimate Hours:  
Description:      
  Start:    Complete:  

Visible to Requestor Comment User Time
Select [Replied directly by Email with images] Chip, Here is an example, similar to your scenario we think. We have three columns, ID, Money Value and Currency in a table. We have created a drop down for the currency. An Excel Validation formula has been applied to the Currency column. Here we see the task in action : showing validation examples. Here are the Excel validation options set on the Currency column: Error condition message: The Excel formula we have used is: =OR(AND(G1<>0, NOT(ISBLANK(H1))),AND(G1=0, ISBLANK(H1))) The breaks down into two main parts: =OR( -- Valid condition either of the two following clauses are true:- AND(G1<>0, NOT(ISBLANK(H1))), -- G1(Money value) is not 0 AND H1(Currency) is set AND(G1=0, ISBLANK(H1)) -- G1(Money Value) is 0 AND Currency is blank ) The formula could be expanded to include other valid conditions – if there are any. From our understanding this is what you are after – if you could reply to let us know. Lean Software 11/17/2014 9:35:41 PM
Select If you create an Excel validation rule, using a formula. The validation rule cou Lean Software 11/17/2014 7:31:29 PM
Select If you create an Excel validation rule, using a formula. The validation rule cou Lean Software 11/17/2014 7:31:28 PM
Select I have some validations set up -- a lookup on one of my columns. Basically, if one of my fields is greater than zero, the currency code must be populated (otherwise a blank is allowed), and if it's populated, it must be valid (does a lookup in my database). The currency code cannot be null, so I default it to blank. The first part seems to be working - if the field is greater than zero, I does not allow blanks. Where I'm having trouble is when an invalid currency code is loaded initially. The task is not validating the code until one of the other fields is touched. I've attached my task XML. Thanks Invesco Houston USA 11/17/2014 5:29:22 PM

Tags:

Skip Navigation Links.
Bug report
Consultancy
Expand DatabaseDatabase
Feature request
Feedback
Help request