-
-
2. Re: Сombining formulas
Aleks Roth Sep 3, 2016 8:42 PM (in response to Mahfooj Khan)1 of 1 people found this helpfulHello, thank you for your help.
Sorry, I'm not completely write an example.
Line: 3."The problem is not current" must be extracted from the group NULL.
Line:1,2,3,4 are typical examples, but there are also has other lines that diferent from lines:1,2,3,4
Example:
5. software install failed
6. windows install not successful
lines 5,6 must be included in group NULL.
I want to get a formula which will bring the table below:
RESOLUTION COMBINED
resolution(01:01) Completed repair equipments, 01:01
resolution(01:02) Preventive maintenance, 01:02
resolution(01:03) Completed repair equipments. The problem is not current, 01:03
software install failed, NULL
windows install not successful,NULL
-
3. Re: Сombining formulas
Mahfooj Khan Sep 3, 2016 11:33 PM (in response to Aleks Roth)1 of 1 people found this helpfulThe formula only brings you the extracted values from your [Resolution] field. To filter out Line3 from the result set the easiest you is just put a filter on your [Resolution] field and exclude the Line3.
Or you can create a calculated field to filter line 3. Drag the field in filters shelf and select True.
Hope you get my point.
Mahfooj