How do I display a calculated column on my Summary Report?

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
How do I display a calculated column on my Summary Report? I have a calculated column with a text formula, I have <calculated column> selected, but it won't display. Also potentially related is that fact that all of my columns are listed as numeric, even "addresses" that are an address type field. New user here, thanks!
Photo of CMHQB

CMHQB

  • 80 Points 75 badge 2x thumb
  • Frustrated!

Posted 5 months ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Hi, what are you trying to calculate through that field?

Thanks,
Gaurav
Photo of CMHQB

CMHQB

  • 80 Points 75 badge 2x thumb
I'm trying to display the text to be written on a wedding invitation. The formula checks if they have a +1, whether their last names are the same, etc. See below:

If([Is a +1?]=null,If([Bringing a +1?]=null,[First Name]&" "&[Last Name],If([Last Name]=[+1 Last Name],[First Name]&" & "&[+1 First Name]&" "&[Last Name],[First Name]&" "&[Last Name]&" & "&[+1 First Name]&" "&[+1 Last Name])),null)