9 Replies Latest reply on Jun 7, 2012 2:41 AM by Jonathan Drummey

    How do I embed filters within a calculated field?

    Julie Sok

      Hi,

       

      I am having trouble filtering my data using table calculations. I would like to keep my entire pool of 1093 entities but when I place in my employment filters (JOB_STATUS_CODE =" E"; PRIMARY_EMP_IND= "Y") as I have in Sheet 1, I lose entities that do not meet this criteria. In an attempt to fix this problem, I have created a calculated field that have the filters embedded within them. However, the results for "Job Title" and "Employer" are incorrect when I do so (Sheet 2).  I'm using "max" as an aggregation for Employer Name in attempt to drop the null categories.  I've also tried ATTR.  Any help would be greatly appreciated.