AnsweredAssumed Answered

bug with filtervalues

Question asked by rounakjain on Jul 1, 2012
Latest reply on Jul 2, 2012 by rounakjain

Title

bug with filtervalues

Post

If (IsEmpty ( FilterValues ( List ( GI Fitting Price List::PL ItemName);Product Name ));

Product Name & " " & Product Size;

Product Name & " " &  Substitute ( Product Size; ["20";"3/4"];["15";"1/2"]))

 

Example:

GI Fitting Price List table has two fields: "PL ItemName" & "PL ItemSize"

"PL ItemName" contains "Elbow"

"PL ItemSize" contains "15"

The fields Product Name and Product Size are from table "Invoice".

When I enter "Elbow" in Product Name and "15" in Product Size I get Elbow 1/2 (as expected) with the above IF statement.

However, when I enter "Elbow" in Product Name and "20x15" in Product Size I get Elbow 20 x 15 instead of the expected Elbow 3/4 x 1/2

Then I added a new entry in the GI Fitting Price List table with "PL ItemName" = "Elbow" and "PL ItemSize" = "20 x 15". Then I got the correct result.

I don't understand what does the above if statement has to do with "PL ItemSize". It seems like a bug.

Outcomes