，使用公式计算，出现了无穷大的情况，如何把无穷大用/替换

计算公式如下:IF(sum(ds2.select(sale_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄"))) = 0, "/", sum(ds2.select(sale_stock_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄"))) / sum(ds2.select(sale_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄")))),求助：如何把无穷大用/替换

FineReport 夏夜星空海 发布于 2021-8-3 08:37

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答

axingLv6专家互助
发布于2021-8-3 09:21

除数被除数为零的处理-https://help.fanruan.com/finereport/doc-view-367.html

luojian0323Lv7资深互助
发布于2021-8-3 08:39

直接根据分子分母有一个是0就转换成"/"

snrtuemcLv8专家互助
发布于2021-8-3 08:43

IF(or(sum(ds2.select(sale_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄"))) = 0,sum(ds2.select(sale_stock_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄")))=0), "/", sum(ds2.select(sale_stock_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄"))) / sum(ds2.select(sale_skunum_14, season= "夏季" && (product = "苹果" || product = "葡萄"))))