Thanks much! One of the 2019 World's Most Ethical Companies® Jones Lang LaSalle For more information about how JLL processes your personal data, please click "http://www.jll.com/privacy-statement">here . This email is for the use of the intended recipient(s) only. If you have received this email in ...
Hello, Does anyone know how to "ignore" a blank field in a custom field average calculation? Example: AVERAGE(Comp1,Comp2,Comp3) Comp1 =30 Comp2=30 Comp3 is blank Average = 20 (should be 30) Thanks! Patricia Greene JLL
You can try "&&" as your AND ... And && Use this modifier to indicate that the condition is fulfilled when the expression finds an item that fulfills two conditions at the same time. For example, use the following statement in a calculated custom field to build an "IF" statement that finds projects ...