I have a table for the daily report of the state of machinery; to avoid duplicating a record I need to validate the date and the machine code, I used this condition but it doesnโt work for me, what am I doing wrong?
AND(COUNT(SELECT(Machinery daily report[ID RDM],[CODE]=[_THISROW].[CODE]))=0, COUNT(SELECT(Machinery daily report[ID RDM],[DATE]=[_THISROW].[DATE]))=0)
Solved! Go to Solution.
Do only one COUNT( SELECT()), and use the AND() in the SELECTโs condition.
Also, ISBLANK() is roughly equivalent to COUNT()=0, and is arguable easier to read and cleaner code.
Do only one COUNT( SELECT()), and use the AND() in the SELECTโs condition.
Also, ISBLANK() is roughly equivalent to COUNT()=0, and is arguable easier to read and cleaner code.
Thanks Marc
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |