I have created a report between two objects, Both objects are related to each other I have an assignment object where one field is called Role And
one object resource object where one field is called Resource role I need to add that filter that shows these both roles are not equal to each other. Like IF the assignment role is the manager and the resource role is a manager doesn't want to see those data but if assignment role and resource role is different only report should be shown those data.
8 个回答
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi Aamir,
You could create a formual field on the child object that would return a checkbox if both roles are equal.
You can then filter your report by checkbox formula equals false