Redirect Data Buffer result
Hello,
I am trying to adjust the code below to handle the following situation:
The client loaded data for Test Rate and Test Count on UD1 "ID".
The data buffers defined for prior month (TotDirC...
Forum Discussion
For dealing with data that may not exist where you need to divide, you can add ternary check for 0 and set the value to 1 instead.
TestRate = If(TestRate<>0, TestRate, 1)
Hi Robb,
The data buffers should look at prior period. The Test factors should look at current period, as how the code shows.
Data buffers do not have values on UD1 ID on prior period.
Test factors have data on UD1 ID on current period.
The calculation logic should be = DirCOGSDataBuffer / TotDirCOGSDataBuffer * Test Rate * Test Count, where
DirCOGSDataBuffer and TotDirCOGSDataBuffer are values from prior period on UD1 ID
Test Count and Test Rates are values from current period on UD1 ID
But the problem is DirCOGSDataBuffer and TotDirCOGSDataBuffer do not have values on UD1 ID in prior period. Because of that, the client wants to use another UD1 member, let's say UD1 A, and replace the calculation as follows: DirCOGSDataBuffer UD1 A / TotDirCOGSDataBuffer UD1 A * Test Rate UD1 ID * Test Count UD1 ID.
The result should be placed on UD1 ID.
This should happen only for this special cases when there is no data on certain UD1's for prior period. The rest of the cases should follow the logic as it is now in the code.
When faced with complexity in programming, the answer is to break the logic down into smaller, more manageable chunks.
- Create a sub containing only the calculating activity, accepting parameters for the elements that are going to change.
- Create a function that will return True/False depending on whether there is data in previous periods. Again you will need some parameter, it might well be a buffer.
- Have a simple If/Then/Else switch that, depending on the results of 2, will run 1 with some parameter or other.
Do this first, check the results are correct, then worry about ways to speed things up later.
