The standard in out-of-the-box reports for displaying an asterisk (*) next to a numerical value in report designer is to make a separate textbox with the character and set the visibility condition to display the asterisk when needed. This has the added benefit of allowing stylization on the asterisk character.
Would this work for your use case?
Hi Robert, Thank you for your input.
I started out on that path, however, I am trying to consolidate all the conditions into variables, which are then utilized in many calculations throughout the report. This way, if the calculation for something is edited we only have to edit it in one variable and not in every instance in which the data is used throughout the report.
If I build in a text box after every field in the report, then we will also have to edit the conditions in multiple fields when one piece of the calculation is changed. The chances of not locating every instance that needs editing would lead to a higher chance of future errors.
For example, one variable will pull actual costs from the account groups of a project, unless they are zero, in which case it will put from the revenue budget.
This cost or budgeted cost is then utilized in calculating FOB and so on through the report. I am trying to make it show an asterisk at the end of any calculation that utilizes the budgeted data rather than the actual data.
Regards,
Helen
Hello, if you share your .RPX we can help troubleshoot. As an alternative you can set the visible expression on the asterisk field to evaluate the existing or a new attribute.
Here are some examples:
Visible Expression: =@IsVisible
Visible Expression =@ExistingVariable>0