Forum Discussion

unclejemima's avatar
unclejemima
Post Patron
2 years ago

Report level filter not working on a calculation

I have a report that calculates how much product we have on order of a given product.  To get the results, I have a "SUM" calculation from a different table.   I have a calculation that looks like ...
Need Help
unclejemima's avatar
unclejemima
Post Patron
2 years ago

"@unclejemima does stok table have a relationship with the supplier table?"

 

parry2k , No it does not.

 

Though I could create a relationship between the STOK and INVENTRY table.  The Supplier name exisits in both those tables.

 

Is there a way to modify the original calulation to filter OUT the SUPPLIER-A

 

This would be an easy solution.

 

 

 

  • unclejemima's avatar
    unclejemima
    Post Patron
    2 years ago

    I should also point out, have a LOOKUP formula in the STOK and INVENTRY that pulls the supplier name from the SUPPLIER table.  


    IMy filter shows that it finds 11 records of the SUPPLIER-A from the STOK table...but applying the filter does not change the CALCULATE(SUM results


    I'm assuming again that this is a design of the CALCULATE(SUM and that the results can not be filtered in a report like I normally would?  This is why I'm looking to apply a change to the calculation so it filters the actual calculation from the get go.