Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using Only or Concat or MinString or MaxString
May be using Only or Concat or MinString or MaxString