Formulas in Webi

[Former Member]

Hi,

I have data like

Name   Sub    Flag

------------------------------

A          E         Y

B          E         Y

C          F         N

D          F         N

E          T         N

A          T         Y

C          G        Y

D          H         N

want to display no.of counts (Name) where Flag='Y' and no.of counts(Name) where flag='N'. Note - Name is dimension

Eg: Name - 4 (Flag=Y)

      Name - 4 (Flag=N

Can anyone help.

Regards,

Rajesh

[CdnConnection · Accepted solution]

Rajesh,

     If you want to count all Name when Y, the formula would look like,

= Count (<NAME>  Where ( <Flag> ="Y"))

Ajay