SQL error - discounted price | BI publisher multiplication issue. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL error - discounted price | BI publisher multiplication issue.

edited Aug 22, 2025 3:42PM in Reporting and Analytics for SCM

I'm in the process of generating the cost price list, but I'm encountering a runtime error.
The error message doesn't provide specific details, so the root cause is unclear.
However, the SQL statements appear to be executing writes correctly,
and both components—the price list and the discount list—function properly on their own.
Could you tell me if there are any improvements that can be made to the SQL structure?

[ADD]

An error seems to occur due to the multiplication in the SQL.
Could you tell me how to perform multiplication in SQL without encountering an error?



Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!