注册

-6103: 除0错误

🙉 2024/08/15 610 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:win
【CPU】:
【问题描述】*: SELECT
ORG_CODE as orgCode,
ENTPRISE_ID as entpriseId,
BOOK_YEAR,
BOOK_MONTH,
NAME as name,
ifnull( UNREIMBURSE, 0 ) AS unreimburse,
ifnull( UNREIMBURSE_SUM, 0 )AS unreimburseSum,
ifnull( UNREIMBURSE_LAST_SUM, 0 ) AS unreimburseLastSum,
ROUND((ifnull( UNREIMBURSE_SUM, 0 )-ifnull( UNREIMBURSE_LAST_SUM, 0 ))/ifnull( UNREIMBURSE_LAST_SUM, 0 ),2)*100 AS percentage,
ABS(ROUND((ifnull( UNREIMBURSE_SUM, 0 )-ifnull( UNREIMBURSE_LAST_SUM, 0 ))/ifnull( UNREIMBURSE_LAST_SUM, 0 ),2))*100 AS percentageOrder
FROM
zszx.EM_ENTPRISE_TAX_RP
ORDER BY percentageOrder DESC

回答 0
暂无回答
扫一扫
联系客服