Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subtract Custom Expressions

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.

1 Solution

Accepted Solutions
CarlosAMonroy
Creator III
Creator III

Hi Nicole,


Use:


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

column(1)-column(2) or

expression in column1 - expression in column2


Carlos M

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Are they columns in a straight table?

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

Not applicable
Author

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
Not applicable
Author

Can you provide an example app?

Anonymous
Not applicable
Author

Try.  The column names should be blue.

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

CarlosAMonroy
Creator III
Creator III

Hi Nicole,


Use:


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

column(1)-column(2) or

expression in column1 - expression in column2


Carlos M

Not applicable
Author

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