有没有办法写这个表达式更好，更简单 [英] Is there a way to write this expression that reads better and more simple

问题描述

IF（IF（SearchImpressionShare = 10.0,2.4，SearchImpressionShare）> 0，合并（展示次数，  0）/

  IF（SearchImpressionShare = 10.0,2.4，SearchImpressionShare），展示次数/ 100）* 100 AS AvailableImpressions，

IF(IF(SearchImpressionShare = 10.0, 2.4, SearchImpressionShare) > 0, coalesce(Impressions,  0)/
 IF(SearchImpressionShare = 10.0, 2.4, SearchImpressionShare), Impressions/100)*100 AS AvailableImpressions,

推荐答案

希望你的意思是IIF

Hope you meant IIF

 SELECT coalesce(Impressions,  0)/IIF(SearchImpressionShare = 10.0, 2.4,IIF( SearchImpressionShare > 0 ,SearchImpressionShare,0.01)) * 100

这篇关于有没有办法写这个表达式更好，更简单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！