Conditional count of values from another object. Please?
Hi,
I was wondering if anyone would have any advice about how do the following, please.
I´ve got a straigt table where dimension is Number of Risks from 1 to 30 for example and then expressions are if formulas.
Eg.Check 1... If (DOB=AGE, 'GOOD', 'ERROR'). I have different expressions but the result for all of them for each risks would be GOOD or ERROR.
I´ve also got different set or risks. E.g. Set A = risks from 1 to 30 (expression will give a GOOD or an ERROR for each risk)
Set B = risks from 50 to 100 ((we can have different checks/expressions than in Set A)
What I want to do is in another object (straight table probably) to count the number of GOOD and ERROR by check and set but not by risk (risk shouldn´t be a dimesion I think).
