PS Query & SQL

Okay, I'm attempting to create a "fall version" and this is UGRD only at the moment to determine what to reduce students to.  I'm not even sure I'm rounding correctly.  But, this is what I'm trying to get the query to do.

High Offer / #Disb = 550.33333  -->  I want that to round down to 550.

Then, multiply the (550 * 83 / 100) * 100  (Because they want to see 83 instead of .83).  That comes to 456.5.  --> I want that to round down to 456.

I'm getting 458.  WHY??????  I've tried replacing ROUND with TRUNC also.

This is my Expression: 

(ROUND(B.HIGHEST_OFFER_AMT / COUNT(DISTINCT H.DISBURSEMENT_ID),0)
*
(Case

When
(SUM(Case
When F.STDNT_ENRL_STATUS = 'E' AND F.EARN_CREDIT = 'Y' AND F.UNT_PRGRSS_FA > 0
Then F.UNT_PRGRSS_FA
Else 0
END) *COUNT(DISTINCT F.EMPLID || F.ACAD_CAREER || F.INSTITUTION || F.STRM || F.CLASS_NBR)/COUNT(*))
>= 12
Then 100

Else

(ROUND(SUM(Case
When F.STDNT_ENRL_STATUS = 'E' AND F.EARN_CREDIT = 'Y' AND F.UNT_PRGRSS_FA > 0
Then F.UNT_PRGRSS_FA
Else 0
END) *COUNT(DISTINCT F.EMPLID || F.ACAD_CAREER || F.INSTITUTION || F.STRM || F.CLASS_NBR)/COUNT(*),0)/12) * 100

End)/100)

<scribe-shadow id="crxjs-ext" data-crx="okfkdaglfjjjfefdcppliegebpoegaii" style="position: fixed; width: 0px; height: 0px; top: 0px; left: 0px; z-index: 2147483647; overflow: visible; visibility: visible;"></scribe-shadow>

You could look at using Floor, Ceiling and Mod to adjust the numbers.

e.g.

select  floor(550.33333) from dual;
select  ceil(550.33333) from dual;
select  mod(550.33333,1) from dual;

SELECT
    CASE
        WHEN mod(550.33333,1) <= 0.5 THEN
            floor((550.33333))
        ELSE
            ceil((550.33333))
    END AS roundedValue
FROM
    dual;

SELECT
    CASE
        WHEN   mod((550 * 83) / 100,1) <= 0.5 THEN
            floor((550 * 83) / 100)
        ELSE
            ceil((550 * 83) / 100)
    END AS roundedValue
FROM
    dual;

Okay, I'm attempting to create a "fall version" and this is UGRD only at the moment to determine what to reduce students to.  I'm not even sure I'm rounding correctly.  But, this is what I'm trying to get the query to do.

High Offer / #Disb = 550.33333  -->  I want that to round down to 550.

Then, multiply the (550 * 83 / 100) * 100  (Because they want to see 83 instead of .83).  That comes to 456.5.  --> I want that to round down to 456.

I'm getting 458.  WHY??????  I've tried replacing ROUND with TRUNC also.

This is my Expression: 

(ROUND(B.HIGHEST_OFFER_AMT / COUNT(DISTINCT H.DISBURSEMENT_ID),0)
*
(Case

When
(SUM(Case
When F.STDNT_ENRL_STATUS = 'E' AND F.EARN_CREDIT = 'Y' AND F.UNT_PRGRSS_FA > 0
Then F.UNT_PRGRSS_FA
Else 0
END) *COUNT(DISTINCT F.EMPLID || F.ACAD_CAREER || F.INSTITUTION || F.STRM || F.CLASS_NBR)/COUNT(*))
>= 12
Then 100

Else

(ROUND(SUM(Case
When F.STDNT_ENRL_STATUS = 'E' AND F.EARN_CREDIT = 'Y' AND F.UNT_PRGRSS_FA > 0
Then F.UNT_PRGRSS_FA
Else 0
END) *COUNT(DISTINCT F.EMPLID || F.ACAD_CAREER || F.INSTITUTION || F.STRM || F.CLASS_NBR)/COUNT(*),0)/12) * 100

End)/100)

<scribe-shadow id="crxjs-ext" data-crx="okfkdaglfjjjfefdcppliegebpoegaii" style="position: fixed; width: 0px; height: 0px; top: 0px; left: 0px; z-index: 2147483647; overflow: visible; visibility: visible;"></scribe-shadow>