I have a few fields that are edited with a display string. The report looks fine when I preview it. When I try to export it to Excel (data only), the display formula fails. Am I missing a setting or does this not work with Excel (data only)? Here is one of the formulas I'm using.
if {BBT.Reside Type} = "Primary" then "1" else if {BBT.Reside Type} = "Secondary" then "2" else "3"
When I export I get "Primary" and "Secondary"
Thank you in advance,
Robert
IP Logged