Get only one value from the table

[Anonymous]

Hi.

Is there any way where I can get only one perticular value from a table.

For Example in the above table I want to get the value where Month is May. I tried using if but it works if only i select the month. can anyone tell me how to use set analysis or any method to get this done as I wont be doing any selection in this table. I only need the value for a perticular month only.

[Anonymous]

Or if possible can I get the position of 'MAY' in the record. Like  that I can get the corresponding value for that month.

[perumal_41]

Hi,

Try this Expression Sum({<Month={'May'}>} Field).

This Expression helpful for U

Regards ,

Perumal A

[lalitinmbd]

You ca use any of the following

1.Sum(if(Month='May',Value))

2.Sum({<Month={'May'}>} Value)

Hope this help you Out.

[Anonymous]

Thank you, but I am sorry that I missed one point. I cant use sum as my field contains Alpha Numeric values, like below.

[CELAMBARASAN]

Hi,

     You can get the position and the value by using this function

          FieldValue('Value',FieldIndex( 'Month', 'May' ))

This may help you

Celambarasan

[CELAMBARASAN]

Or you can use

          Concat({<Month={'May'}>} Value,',')

          Or

          MinString({<Month={'May'}>} Value)

Celambarasan

[perumal_41 · Accepted solution]

Hi,

Try this Expression only({<Month={'May'}>} Field).

This Expression helpful for U

Regards ,

Perumal A