Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My challenge is to create an object with dynamic notes/comments from my business users. My solution is to provide them an excel sheet where they will add the comments they want added to the report(s), pull that in during my load, and display in the report. It works but it's a little clumsy. Take a look at the example where I added some fake data. Notice how in my text object I am hardcoding the unique identifier (RowNumber) in my only() funtion so that only one value will be returned per row. I am forced to do this since this is a text object and not a chart (aggegration permitted).
Can anybody think of a way I can use a text object and display all three rows of data ... without having to hardcode the unique identifer? Like I said this approach works but is not ideal.
Thanks for anything.
Try this:
=concat(
aggr(
Author& ' - ' & Date(Date) & ':' & chr(13) & Note
, RowNumber
)
, chr(13) & chr(13)
, RowNumber
)
Try this:
=concat(
aggr(
Author& ' - ' & Date(Date) & ':' & chr(13) & Note
, RowNumber
)
, chr(13) & chr(13)
, RowNumber
)
Fernando perfect! I forget about the usefullness of the concat() function. That married with aggr() hit the spot.