Using two entities in a Report Builder filter expression

  • I am wondering if anyone has any idea if it is possible to using two entities in a Report Builder filter formula expressision.

    I have a model which contains an Transactions entitie and a Non Financial Transactions entitie.

    In a sense, I will be joining the two entities via the filter express using a formula, For example, the primary filter would use attributes from the Non Financial Transactions entity. This sets the base condition for the report, which will have attributes from the Transactions entities. The trick is to return only the records from the transactions entity that match the Non Financial Transactions filter criteria.

    So, I am thinking we would have to create a formula where by Non Financial Transactions.account number is in Transactions.account number

    Any ideas?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply