By using this website, you agree to our Terms of Use (click here)
Hello All,
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.
Thank You!!
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!!
If you cannot pull a column into another as a calculation, why is there a box to make a column not visible? This seems like it would be to make a temp variable that could be used in another column. Am I missing another reason for the visible checkbox?
The Visible checkbox just puts the column into the "additional columns" area that a user can add to the grid if they choose. That's covered in one of the lessons of my Building Generic Inquiries & Pivot Tables course (click here).
@timrodman have to admin I've never paid much attention to Visible. Now that I know what it does I might start adding some columns to future GIs I build with Visible off for advanced users. Really useful!
@roycelithgo Ya, I like it because you can add a bunch of columns to a Generic Inquiry, then users get to pick the ones that they want and Acumatica remembers which columns each person likes to see displayed by default.