如何在BusinessObjects 4.2中添加到我的自定义Script max函数

2020-09-08 03:28发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我具有以下自定义脚本,并且我试图...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我具有以下自定义脚本,并且我试图添加sql脚本以仅提取V_SERVICEMETERREADING.SMU的最大数量

我的脚本如下:

选择

V_SERVICEMETERREADING.MACHINE_N,

V_SERVICEMETERREADING.READINGDATE,

V_SERVICEMETERREADING.SMU_Q,

V_SERVICEMETERREADING.SMU

V_SERVICEMETERREADING

在哪里

V_SERVICEMETERREADING.READINGDATE>(从双中选择sysdate-1)

AND

V_SERVICEMETERREADING.SMU_Q> 2

AND

V_SERVICEMETERREADING.MACHINE_N

'174672',

'174674',

'174675',

" 174677",

'174678',

'174679',

'194617',

'304206',

'304207',

'304215',

'304243',

'304244',

'304245',

'304246',

'304247',

'304248',

'304249',

'314266')

2条回答
悻福寶寶
2020-09-08 03:59

你好丹尼尔

您能帮我试试下面的自定义脚本吗?


选择V_SERVICEMETERREADING.MACHINE_N,V_SERVICEMETERREADING.READINGDATE,V_SERVICEMETERREADING.SMU_Q,MAX(V_SERVICEMETERREADING.SMU)

从V_SERVICEMETERREADING

V_SERVICEMETERREADING.READINGDATE>(从双中选择sysdate-1)AND V_SERVICEMETERREADING.SMU_Q> 2 AND V_SERVICEMETERREADING.MACHINE_N in('174672','174674','174675','174677','174678','174679 ','194617','304206','304207','304215','304243','304244','304245','304246','304247','304248','304249','314266')

按V_SERVICEMETERREADING.MACHINE_N,V_SERVICEMETERREADING.READINGDATE,V_SERVICEMETERREADING.SMU_Q分组


Shankar

一周热门 更多>