AnsweredAssumed Answered

FilterElements Problem

Question asked by Gilo on Mar 23, 2015
Latest reply on Mar 23, 2015 by philmodjunk

Title

FilterElements Problem

Post

Hi

I have a field which can get 0 or 1 as value. Right now I'm using this formula, which works nearly ok:

Falls(NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "Opus Life - Equatoria" ) ) = 1; "1";
NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "Opus Life - Azzura" ) ) = 1; "1";
NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "VivaZen" ) ) = 1; "1";

0)

Sorry that's in german, but i should be about: 

Let (NOT ISEMPTY (FilterElements (List (table:fieldA); "ProductA")) = 1 ; "1";
NOT ISEMPTY (FilterElements (List (table:fieldA); "ProductB")) = 1 ; "1";
"0")

This works for fieldA but I need now, that FieldA corresponds to "productA" or "productB" but also that fieldB = "in stock".

I've tried with AND but did not get it to work. Can someone help?

 

Outcomes