• How to automate excel data send with different parameters and emails addresses from external data source

    We have customer open sales order report in SEI. It has customer number as a parameter. We want to run this report automatically and send it in email to different customers, using input from another csv file. For example, I have CSV file Customer…
  • SEI Subtotal Average Rounding & Incorrect Value

    Hi, I'm currently looking into some strange behavior in how SEI is subtotaling values. Specifically I have a report where I want to see the Average value of our costs. Rounding to the Nearest Dollar For illustrative purposes, I'm going to use our…
  • Using Calculated Columns in Formula within another Calculated Column in SEI

    [SEI v.8] Can I reference a Calculated Column I created in the calculation of another Calculated Column? If so, what is the syntax to refer to a Calculated Column within the SQL Scripts Builder? Usually when referring to to a field within a calculation…