Providing more than one condition in Layout

[#1]

Is there a way to provide two conditions in layout? I have a grid which I want to show only if two conditions are fulfilled. I provided the condition in the layout tab as "=Value=1 and vDetailId=2" but this is not working out.

Thanks in Advance

[jonathandienst · Accepted solution]

Hi

Your condition looks OK, but you could also try

=If(Value = 1 And vDetailId = 2, true(), false())

Hope this helps

Jonathan

[SunilChauhan]

no need to write in double quotes (" ")

use below instead

=Value=1 and vDetailId=2

[its_anandrjs]

Hi,

You have to write in Chart -> Properties -> Layout -> Conditional

and paste a code there

If( Value = 1 And vDetailId = 2 , 1, 0)

And try to set different value for variables Value and vDetailId but it works only when it is 1 and 2

See the attached sample file.

Rgds

Anand

[#5]

Thanks !!!   This worked like magic