This content has been marked as final.
Show 3 replies
-
1. Re: Concatenating?! string + aggregate
Wesley Magee Apr 4, 2018 4:05 PM (in response to Benjamin Cole)Benjamin,
Have you tried wrapping the [Author Name] in an attribute function?
ATTR([Author Name])
-Wesley
-
2. Re: Concatenating?! string + aggregate
Deepak Rai Apr 4, 2018 4:33 PM (in response to Benjamin Cole)you can use any one out of MIN,MAX, ATTR with Author Name
as MIN(Author Name)+STR(COUNTD([Title]))
Similarly for MAX and ATTR
-
3. Re: Concatenating?! string + aggregate
James RowntreeApr 4, 2018 4:43 PM (in response to Benjamin Cole)
Hi Benjamin,
Have a look at this thread: Concatenate count of date (integer) and a string?
Basically, Anna Cheetham suggested using FIXED to force the issue. Something like this...
- [Author Name] + ' ' + str({ FIXED [Author Name] : countd([Title])})
It worked in the attached (very simple) example on superstore in 10.5.2