If you’re working on a shipping application that requires users to fill in a country code for international shipping, you could use a List Custom Setting of all country codes. Users can then access this information without needing to query the database (ie. this doesn’t count towards your...
Regarding my comment about arranging the source data in order by business unit, then by establishment, I meant the data for the picklists needs to be sorted (or grouped) by the first two columns. Since the formulas are basically finding the first match in the list ...
INSERT INTO "MOLJUS02"."TEST_WHITESPACE_FACT" VALUES ('', 100); INSERT INTO "MOLJUS02"."TEST_WHITESPACE_DIM" VALUES ('1234567', 'BLUE'); INSERT INTO "MOLJUS02"."TEST_WHITESPACE_DIM" VALUES ('1238890', 'RED'); --Simulate a dim/fact query SELECT B."ATTR1", SUM(A."SALES") ...
This works perfectly for the first row, but I can't apply it to subsequent rows because of the reference to M5 or N5. Wondering how I can make that cell reference relative. I haven't been able to work out how to use the OFFSET function or anything else. One method you could try...
Regarding my comment about arranging the source data in order by business unit, then by establishment, I meant the data for the picklists needs to be sorted (or grouped) by the first two columns. Since the formulas are basically finding the first match in the list and the last match ...
Regarding my comment about arranging the source data in order by business unit, then by establishment, I meant the data for the picklists needs to be sorted (or grouped) by the first two columns. Since the formulas are basically finding the first match in the list...
Regarding my comment about arranging the source data in order by business unit, then by establishment, I meant the data for the picklists needs to be sorted (or grouped) by the first two columns. Since the formulas are basically finding the first match in the list and the last match ...