⟩ What is the difference between condition & filter?
Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)
Filters - are used to restrict the number of rows in the output.
Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.
For Eg: select cust_id from customer where cust_name like 'A%'
Filter is Cust_name like 'A%'.
Condition is also applied at report level.
If (cnt(cust_id) > 1 ;"Valid";"NotValid")