Er report showing only one record in the excel

Posted on by Vishnu@94

This is my model. I have added a new node Terms and condition of type under the model.

I have a created a new table for storing the terms and condition for the PO orders. I added a calculated field in the model mapping and added this formula.

FILTER
(
    TermsAndCondition,
AND
    (
    TermsAndCondition.dataAreaId = Variables.'$PurchPurchaseOrderHeader'.dataAreaId,
    TermsAndCondition.PurchId = Variables.'$PurchPurchaseOrderHeader'.PurchId
    ) 
)
 
This is binding I did in the model mapping
 
 
and this is my format mapping
 
I have 2 records in my custom table but when I generate the report it is showing only one record
 
Report