
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nicole,
Use:
[YTD 2017 Sales]-[YTD 2016 Sales] or
column(1)-column(2) or
expression in column1 - expression in column2
Carlos M

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are they columns in a straight table?
If so, you can just add an expression that subtracts them using their column names.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you provide an example app?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try. The column names should be blue.
=[YTD 2017 Sales]-[YTD 2016 Sales]


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nicole,
Use:
[YTD 2017 Sales]-[YTD 2016 Sales] or
column(1)-column(2) or
expression in column1 - expression in column2
Carlos M

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks everyone! column(1)-column(2) worked!!
