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?
Are they columns in a straight table?
If so, you can just add an expression that subtracts them using their column names.
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'
Can you provide an example app?
Try. The column names should be blue.
=[YTD 2017 Sales]-[YTD 2016 Sales]
[YTD 2017 Sales]-[YTD 2016 Sales] or
expression in column1 - expression in column2
Thanks everyone! column(1)-column(2) worked!!
Retrieving data ...