ContributionsMost RecentMost LikesSolutionsRe: Implementing a stack rank function?Thanks Good NightRe: Implementing a stack rank function?Much Higher 690Re: Implementing a stack rank function?I need a field that can be used on multiple reportsRe: Implementing a stack rank function?Hey so I am trying to rank based off of a calculation. My calculation returns a value (i.e. 100,115, 50,000, 10,000, 2103) I want those values ranked 1 through 100 based Highest to lowest. For example, 100,115 would equal 1 and 2103 equals 100, if there were 100 records.Help writing a if statementI have Field one [Type] (text field) and Field 2 [Area] (Related Table numeric: 10,20,30) I have made an additional field [field 3] that I want to show Field 2 unless Field one = Popcorn then Field three to show 40. Re: isNull HelpThanks so much for your helpRe: isNull HelpI added one after OND and removed one from the end, Checking now to see if it works properly Thanks so much for your help!Re: isNull HelpA closing parenthesis is missing. If((isnull([OND Extension]) AND isnull([OND]),[LED], if(isnull([OND Extension]),[OND], [OND Extension]))) I already try added just two parenthesisRe: isNull HelpChuck this is the error I recieved: Expected a valid expression after the "&" If((isnull([OND Extension]) && isnull([OND]),[LED], if(isnull([OND Extension]),[OND], [OND Extension])))isNull HelpMade a new field "OND/LED" I want this field to show the following result if DATE 2 is blank show Date 1 if date 2 and date 1 are blank show date 3. For Example Example 1: Date 2: 01/01/17 Date 1: 11/30/16 Date 3: 12/31/17 OND/LED = 01/01/17 Example 2: Date 2: Date 1: 11/30/16 Date 3: 12/31/17 OND/LED = 11/30/16 Example 3: Date 2: Date 1: Date 3: 12/31/17 OND/LED = 12/31/17 I tried this it didn't work: If(isnull([Date 2],[Date 2]),isnull([Date 1},[Date 1]),[Date 3])