Skip to Content
author's profile photo Former Member
Former Member

为报表增加一个客户需要的列

看到Frank Lee鼓励大家多问问题,我就再问多些啦~~

这个问题目前自己没有想到更好的解决办法::

开发的新报表中,客户还想增加这么一列,假设是A列吧:

1. 若SNP和 MRP(这2列均为KEY FIGURE)的数值都是0,则A列 显示u201CNO DEMAND".

2. 若SNP和 MRP中任何一个不为0,则A列显示u201Csurplus".

我本来想设计一个Calculated key figure,但是 好像不能写逻辑和显示文本是么??要是condition里面,好像也不能同时考虑SNP和 MRP 2列KEY FIGURE,大家能给个方向么??

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2009 at 03:35 AM

    Hi,

    用ckf可以写点儿逻辑,但是不能显示文本。condition里面也不能控制一列显示为no demand或surplus。

    可以做到的是创建一个ckf,当SNP MRP都是0的时候显示0,当SNP MRP任何一个不为0的时候显示1。然后在上面加一个exception,例如0的时候红色,1的时候绿色,看客户的需要了。

    ckf里写以下公式。这样当SNP <> 0 和 MRP <> 0 满足任何一个或两个都满足的时候,值为1。两个都不满足的时候值为0.

    (SNP <> 0) OR (MRP <> 0)

    试试看,要是可以的话你可能得去说服你的客户了。我印象中,bw报表不能做到文字的动态显示。

    Regards,

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Diamond,

      不客气,我也不知道为什么你的系统上只有一个选项,或许你可以去英文的SDN论坛上找找。可能是在什么地方需要额外配置一下。

      我也不明白为什么看不到Log。但如果你能够成功收到邮件,说明是成功运行的了。

      Regards,

      Frank

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2009 at 11:27 AM

    你可以创建一个workbook然后用EXCEL或VB来显示u201CNO DEMAND" & "Surplus"

    具体来说,只要在SNP和 MRP 2列 的右边留个column, 然后用excel formular=IF(SNP+MRP=0,"No Demand", "surplus")

    然后保存报表就可以了,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.