Text

[schumi1980]

Hi All

I would like to allow users to upload comments into a dashboard.

The comments are organized like:

Category Region Premium Comment

1             1

..

10

1             2

..

10

..

If I sum up the premium in a text box I can use the following formula:

Num( sum({<Category={'7'}, Premium
,'#.###,', ',', '.')

Is there a function where I can define that I only want the text from the comment made for category 7.

Like Text({<Category={'7'}>}.

Many thanks for your help.

Jan

[sunny_talwar · Accepted solution]

May be using Only or Concat or MinString or MaxString