Questions Adding Formulas to Results Columns
First let me say I am brand new to this type group sharing/support. Thank you for the opportunity to participate here.
I'm also relatively new to Acumatica but I'm learning.
I have an inquiry for showing sales data year over year by customer and SKU. The columns that represent last year and this year pull that data by using formulas (see attached screen shots.) I would like to add 2 columns, one showing the difference between last year and this year by % plus or minus and the other showing the difference by $ plus or minus. Is there a way to write a formula that would achieve what I am looking for, any help would be greatly appreciated.
Welcome @jmmarasco. Sorry for the late reply on this. Unfortunately you can't reference a calculated column in another calculated column yet, but you could copy/paste your formulas into a new calculated column. Something like calculatedcolumnformula1-calculatedcolumnformula2.
Thank you Tim!!