Continued to modify the application to fix the query and the formula to return the correct and expected value in the textile, tested the modification by debugging and checking the value of the variable in the application, as per checking, there are variables that returned incorrect value thus returned an incorrect net sales, continue the modification to correct the output.