HELP: Where can I add this missing line into my calculation?

[Nathan Wilcox]

Hi Guys,

I've been trawling google and many forums for the last couple of days after numerous failed attempts, I'm now relying on the expertise of all of you. I currently have the following calculation:

If     ( 
    IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ; 
    PatternCount     ( 
                List ( 
                    All Products | Popover::Item ; 
                    All Products | Popover::Supplier ; 
                    All Products | Popover::Internal ID ; 
                    All Products | Popover::Resale Price 
                    ) ; 
                Invoices::Search 
                ) > 0 
    and Invoices::Product Category Filter Popover = All Products | Popover::Category
    )

set up as a portal filter and it performs perfectly to what I needed when I was only testing with a few products in Inventory. I now have 36000+ records and would really like to only show items with a value of more than 0.

I found a suitable calculation (subbed in my own field) on filemaker:

If (All Products | Popover::Stock < 1; 0; 1)

But cannot find the right area to add to my above calculation.

Can anyone help???

Thanks

Nathan

[rwoods]

I would say this should work :-

If (All Products | Popover::Stock < 1; 0;

If     ( 
    IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ; 
    PatternCount     ( 
                List ( 
                    All Products | Popover::Item ; 
                    All Products | Popover::Supplier ; 
                    All Products | Popover::Internal ID ; 
                    All Products | Popover::Resale Price 
                    ) ; 
                Invoices::Search 
                ) > 0 
    and Invoices::Product Category Filter Popover = All Products | Popover::Category
    )

)

 

[Nathan Wilcox]

11 minutes ago, rwoods said:

I would say this should work :-

If (All Products | Popover::Stock < 1; 0;

If     ( 
    IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ; 
    PatternCount     ( 
                List ( 
                    All Products | Popover::Item ; 
                    All Products | Popover::Supplier ; 
                    All Products | Popover::Internal ID ; 
                    All Products | Popover::Resale Price 
                    ) ; 
                Invoices::Search 
                ) > 0 
    and Invoices::Product Category Filter Popover = All Products | Popover::Category
    )

)

 

Thank You So Much. It works Perfect! I now understand what was wrong.

[rwoods]

No problem, please do 'Like' any posts that you find helpful on the forum ;-)