Display value from field

[#1]

Hi all,

A simple question, how can I just show the value from i field in a syntax like this:

??????({$<WeekCounter={">$(#=max(WeekCounter-4))"}}>} Head_goal)

Head_goal has values like 97,0. So I don't need sum or count any value.

Thanks!

[Nicole-Smith · Accepted solution]

I think you may be looking for the only() function:

only([{set_expression}][ distinct ] [ total [<fld {, fld}>]] expression)

If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned. Only can return numeric values as well as text values.

Examples:

only( Sales )

only( Price*Quantity )

only( total Salesman )

However, if you have more than one value, you may want to use concat() as only() will not show anything if there is more than one value in the field.