Category
Report Builder
Product Version
8.0
Reference Code format not prevailing when using "Concatenate" Advanced Function
Answered
Using application 8.0.9 version.
Here's the expectation for Year and Month concatenate fields, the format for Month must include a zero:
2020 09
2020 10
2020 11
2020 12
2021 01
2021 02
Using Reference Codes helps to show the Month format as desired, however, when this field is concatenated (using Advanced Function), the format of the reference code is not prevailing:
The same question
I was able to figure this out.
It is required to create an additional Reference Code, using in "Code" the values as the Concatenate function is displaying the data:
After using the Concatenate function, just change the format of the field to use above Reference Code.
I was able to figure this out.
It is required to create an additional Reference Code, using in "Code" the values as the Concatenate function is displaying the data:
After using the Concatenate function, just change the format of the field to use above Reference Code.
HI Alicia,
Thanks for reaching out with your question. Glad to see you were able to come up with a solution for this! I'll mark this question as Answered, hopefully this info will be useful to someone else in the Community!
Thanks,
Eric
HI Alicia,
Thanks for reaching out with your question. Glad to see you were able to come up with a solution for this! I'll mark this question as Answered, hopefully this info will be useful to someone else in the Community!
Thanks,
Eric
Replies have been locked on this page!