When writing my case fucntions and I select the as District type to be a certain value, how can I tell the function to exclue one of the values of the field that contains the District type.
For example, in the following function, I am saying that when the Customers::Distr_Type = "SA-1" (Customers table, field SA-1) perform the repective cases.
Customers::Distr_Type = "SA-1"; ( If ( Readings_SecondTable::Water_Used_cf >10000 ; Readings_SecondTable::Water_Used_cf - 10000 ; 0 )
I would like to exclude a particular record (row) from the column field SA-1. How would I write this in the formula above?
Thank you for your help.