Hi,
I have an Excel formula that I want to convert to an SQL formula so I can use it in a query.
The Excel formula is:
=D2*CEILING((B2-C2)/D2;1)
I thought I could use RoundUp, but that funcation is not available in SAP.
The formula in SAP looks like this:
t0.purpackun*RoundUp((T1.[Maxstock]-((t1.onhand-t1.iscommited)+ t1.onorder))/t0.purpackun,1) as 'Order quantity',
Request clarification before answering.
Doesn't (recent versions of) Abap SQL handle a CEIL( sql_exp ) function?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.