Forum Discussion

CMHQBCMHQB's avatar
CMHQBCMHQB
Qrew Member
7 years ago

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

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 f...
App builders
Formulas and functions
reports and charts
CMHQBCMHQB's avatar
CMHQBCMHQB
Qrew Member
7 years ago
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)