Filter formula giving #value error

[leatherhen99]

Hi All!

I have tried to search for a solution, but I'm not able to figure out what I'm doing incorrectly with this formula. I can get it to work with one criterion but when I try to use two criteria, it doesn't work...

Heres a small snippet of my table "AuditCriteria"

Q3 = "Jan"
Q4 = "New Hire"

=FILTER(AuditCriteria[[Jan]:[Dec]],AuditCriteria[[#Headers],[Jan]:[Dec]]=Q3)

=FILTER(AuditCriteria[[Jan]:[Dec]],AuditCriteria[Type]=Q4)

this one will not work

=FILTER(AuditCriteria[[Jan]:[Dec]],(AuditCriteria[[#Headers],[Jan]:[Dec]]="Jan")*(AuditCriteria[Type]="New Hire"))

I'm getting a #VALUE error... When I highlight and hove over each section of the code, the small pop-ups are giving me the correct values and/or true/false statements...but I cannot get it to give me the correct information.

Any support would be greatly appreciated!

 

[Fluff]

You need to do a double filter

=filter(FILTER(AuditCriteria[[Jan]:[Dec]],AuditCriteria[[#Headers],[Jan]:[Dec]]="Jan"),AuditCriteria[Type]="New Hire")

 

[leatherhen99]

You need to do a double filter

=filter(FILTER(AuditCriteria[[Jan]:[Dec]],AuditCriteria[[#Headers],[Jan]:[Dec]]="Jan"),AuditCriteria[Type]="New Hire")

That worked PERFECTLY!!!! Thank you so much!!! I watched so many videos and read so many articles, but no one gave that as a solution... thanks again!!!!

 

[Fluff]

You're welcome & thanks for the feedback.