Formula help

[Kieranwood]

Hi all,

I'm building a report in which it needs to count 2 columns if certain criteria is being meant which can be seen below.

The basis of the query is if column Hired contains a date and rec source contains a 1 then enter a 1 into the "custom column" which it does however it's then meant to put a zero in those cells which has a hired date but rec source has a 0 which it doesn't and instead put's a zero in all other columns which then when doing a count/sum it's showing 9000+ cells instead of the 11 which has data in hired.

If someone can lend a hand and advise what the formula would need to be that would be fantastic!

[v-chuncz-msft · Accepted solution]

@Kieranwood,

You may try the following Boolean expression.

(try Date.From([Hired]))[HasError] = false