条件公式设置后,跑数错误

如截图所示,看着有点复杂,但是本质逻辑是比较清晰的。最后富文本呈现的结果有问题,但是不知道哪里出了错误。

image.png

image.png

跑数结果如下:

image.png

富文本内容:

image.png

【销量】${=if(AO17="","","环比↓:" )}${=if(AO17="","",C17)}${=if(AO18="",""," > " )}${=if(AO18="","",C18)}${=if(AO19="",""," > " )}${=if(AO19="","",C19)}${=if(AP17="","","同比↓:" )}${=if(AP17="","",D17)}${=if(AP18="",""," > " )}${=if(AP18="","",D18)}${=if(AP19="",""," > " )}${=if(AP19="","",D19)}【库存周转】${=if(AQ17="","","高周转:" )}${=if(AQ17="","",E17)}${=if(AQ18="",""," > " )}${=if(AQ18="","",E18)}${=if(AQ19="",""," > " )}${=if(AQ19="","",E19)}${=if(AR17="","","环比↑:" )}${=if(AR17="","",F17)}${=if(AR18="",""," > " )}${=if(AR18="","",F18)}${=if(AR19="",""," > " )}${=if(AR19="","",F19)}【退货率】${=if(AS17="","","高退货:" )}${=if(AS17="","",G17)}${=if(AS18="",""," > " )}${=if(AS18="","",G18)}${=if(AS19="",""," > " )}${=if(AS19="","",G19)}${=if(AT17="","","环比↑:" )}${=if(AT17="","",H17)}${=if(AT18="",""," > " )}${=if(AT18="","",H18)}${=if(AT19="",""," > " )}${=if(AT19="","",H19)}

FineReport 帆软用户isPbG51FBd 发布于 2024-10-28 16:36 (编辑于 2024-10-28 16:37)
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
1
华莉星宸Lv7资深互助
发布于2024-10-28 16:40

你把if里面的条件改  AO17=""  

改成  len(AO17)=0

  • 2关注人数
  • 101浏览人数
  • 最后回答于:2024-10-28 16:40
    请选择关闭问题的原因
    确定 取消
    返回顶部