Subtract Custom Expressions

[#1]

Hi,

I made two custom expressions labelled YTD 2017 Sales and YTD 2016 Sales.  I'd like to know how to create a 3 expression subtracting them?

Thank you.

[Anonymous]

Are they columns in a straight table?

If so, you can just add an expression that subtracts them using their column names.

[#3]

They are in a straight table, but when I try subtracting them, I get a blank instead of a number. 'YTD 2017 Sales'-'YTD 2016 Sales'

[Anonymous]

Can you provide an example app?

[Anonymous]

Try.  The column names should be blue.

=[YTD 2017 Sales]-[YTD 2016 Sales]

[CarlosAMonroy · Accepted solution]

Hi Nicole,

Use:

[YTD 2017 Sales]-[YTD 2016 Sales] or

column(1)-column(2) or

expression in column1 - expression in column2

Carlos M

[#7]

Thanks everyone!  column(1)-column(2) worked!!