View some records only

[jimi]

I have two files related by the I_CODE, where I_CODE is the key of the main file (say A) and have multiple existence in second file (:

In a layout of A, the portal view is:

I_CODE="A0001"

key_in_B,value_in_B

B1, 0

B2, 0

B3, 0

B4, 10

B5, 12

....

How can I do, if I do NOT want those zero value records to be shown in the portal?

[BobWeaver]

You need another relationship based on a calculated field in file B.

ExcludeZeroes = case(value_in_B,Key_in_B,"")

Now, the relationship for your portal should be:

A:I_code = B:ExcludeZeroes