Forum Discussion
Most recent value by material by customer
Super UserDo you have multiple calculated columns in your table? If so, that can cause problems when you try to add one that is based on the table you are calcing against (like we are). Can you tell us a bit more about what you are trying to accomplish? There might be another way to get to the same answers.
Im trying to get list prices for our material numbers so that I can then make a "sales margin calculator." However, the only table I can get the list and costs from is a sales table. Unfortunately, this is not a relational table and due to the many instances customers have bought the same product, I need to take the list price from the last transaction. When I did this with the old calculated column it worked but it created an issue where only the last transaction per material would show rather than the last transaction per material by customer.
There are no other calculated columns on the table.