Does anyone know if there is a workaround to make the display value of a field show on the results section of a tabular report? I have multiple fields that store an amount of time in days, but I'd like to display those values in weeks. I.e., the report will show '14' and '70' when I would like it to display "2 Weeks" and "10 Weeks" respectively. The fields already use a lookup table that has both display and actual values saved.
When setting a lookup table for an editable field, you can select the Display Value, but this only shows when editing a record in the results section.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kpcollier
Does anyone know if there is a workaround to make the display value of a field show on the results section of a tabular report? I have multiple fields that store an amount of time in days, but I'd like to display those values in weeks. I.e., the report will show '14' and '70' when I would like it to display "2 Weeks" and "10 Weeks" respectively. The fields already use a lookup table that has both display and actual values saved.
When setting a lookup table for an editable field, you can select the Display Value, but this only shows when editing a record in the results section.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.