Scenario: To display main line criteria, body-level location, and line-level location in the transaction search result, we may use the following formulas
Mainline condition formula :
Formula(text) – Case When {mainline}=’*’ then ‘True’ else ‘False’ end
Body level location:
Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘True’ THEN {location} end
Line level location:
Formula(text) – CASE WHEN (Case When {mainline}=’*’ then ‘True’ else ‘False’ end) = ‘False’ THEN {location} end