Thanks for that. How strange! From what I can see the relationship I have on the SOPickList RDD is identical to yours (see screen print below) but I get the following error when I attempt to run the report: Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Parent Columns and Child Columns don't have type-matching columns.
Hi, just checking if anyone has any other suggestions regarding the above?Thanks.
Thanks for your reply. As I don’t want to get rid of all spaces (i.e. single spaces are ok), I did try to use the replace formula with something like: replace “ “ with “ “ (i.e. replace a double space with a single space). This works, but there are instances of 10 or more spaces. So I “nested” the above a few times, and it reduced the spaces by a bit but not all (unless I keep on nesting). Just wondering if there is a better formula, as I don’t know what is the maximum number of spaces… PS: For the special characters, I’m currently also using the replace function (for commas, diameter symbols, microns symbols, etc).
See screen print of current calculation below:
Thanks for your response.To clarify how the commission is calculates as £1200 it is using the formula provided:(Cost of part with mark-up) / ( 1 - Commission Rate)10,800 / (1 - 0.10) = 10,800 / 0.9 = 12,000If we sell an order with a value of 12,000 and we pay a sales agent 10% commission, their commission will always be calculated as 10% of the “sales value”.So the commission amount to be built into the quoted price needs to be based on the “Sales”, not on the “Total price w/commission” value.If it is based on the “Total price w/commission” value it will be lower, which means that we won’t build enough into the quoted price to pay 10% commission on the sales value.I hope this makes sense.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.