If Condition

[jyothish8807]

Hi

I have 3 columns.

name    Subject    Marks

aa           xx          20

aa           yy          45

bb           ee          33

No i want the count of marks which are <20, between 20 and 50,>50 for each student.

Regards

[narender123]

Hi,

try this.

=count({<marks={"<30"}>}name)

See the attach file.

[#3]

Hi,

in 3 expression:

count({<Marks={"<20"}>}Name)

count({<Marks={">=20"}*Marks={"<=50"}>}Name)

count({<Marks={">50"}>}Name)

[narender123]

you can show this in pivot table for better understand.

See the attachment.

Thanks.

Narender

[CELAMBARASAN]

Try with this

count({<Marks={"<20"}>} Name)

count({<Marks={">=20<=50"} Name)

count({<Marks={">50"}>} Name)