I have posted on SQL forum also, but was wondering if any Wisys Agility Design Studio programmers can help
I am running a pivot grid to determine sales and am needing to get a percentage difference from two Aliases I created. I have the CASE statement below to determine the Difference, but...
So I got a case of the "Staring at the screen too much and cant think"
How would I write the sub query using the Aliases of YTD Diff and YTD 2015 Sales to determine the Percentage difference
YTD Diff/YTD 2015 Sales = xxx.xx%
I am working with Wisys Agility Design Studio and writing SQL statements to determine sales differences from year to year.
Case where I determine the 2016 sales data
CASE
WHEN oehdrhst_wv.inv_dt LIKE '%2016%' THEN ( oelinhst_wv.qty_to_ship - oelinhst_wv.qty_return_to_stk ) *...
I am currently on Macola 9.6.500
In the Print Picking Tickets form, the criteria is to search by a range of order numbers. We use a User_Def_Fld_1 in our Pick Ticket crystal report that is used for a Production Code. Example 11-13-X. I want to be able to modify the Print Picking Tickets form to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.