Alert

[#1]

Hi guys!

I have a table with Employee's name and his salary.

What kind of expression do I need to write in condition of Alert Wizard if I want a popping up alert whenever there is a mising value in salary?

IsNull(Salary) isnt working properly, it always shows me an alert though there are no missing values....

[rubenmarin · Accepted solution]

Hi Diana, depends on data model but maybe:

Count(Employee)<>Count(Salary)

or

Sum(Aggr(If(Count(Salary)=0, 1), Employee))>1