Skip to Content
avatar image
Chuck M

webi variable help

Apr 06, 2017 at 04:28 PM | 59 Views

Hello Experts,

I have 2 date columns both with the following format.

04/04/2017 06:36:56 PM

I want to display only records where the date/time in column 1 is after/greater than column 2

e.g. col1 :04/04/2017 06:36:56 PM col2: 04/04/2017 01:36:56 PM [show this]

e.g. col1 :04/04/2017 06:36:56 PM col2: 04/04/2017 09:36:56 PM [hide this]

Can anyone help?

Thanks

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    AMIT KUMAR
    Apr 06, 2017 at 05:22 PM

    If col1 and col2 objects datatype is date then use this.

    Show/Hide=If([Col1]>[Col2]) Then "Show" Else "Hide"

    After that filter on Show/Hide variable where equal to Show.

    if datatype is string then first convert in the date datatype and use above formula.

    Date1=ToDate([Date1];"dd/MM/yyyy hh:mm:ss a")

    similar for other.

    Add comment
    10|10000 characters needed characters exceeded

    • Chuck M
      Apr 06, 2017 at 08:48 PM

      Hi,

      Its a little more complicated than that.

      I enclose the screenshot.

      There are 3 rows. As row 2 has a modified column time greater than the purchased. The variable I made says YES.

      [= If [Modifications]>[Purchased] Then "YES" Else "NO" ]

      But I need to hide lines 1 & 2 as the orderID is the same.

      Only row 3 should be displayed. (as purchased < modifications)

      we want orderIDs where no modifications have been made.

      In this case line 3 has no such modifs.

      I guess what I am trying to get to is:

      If modified = YES, get the orderID and hide all lines with that orderID.

      Any suggestions?
      webi.png (13.7 kB)
  • avatar image
    AMIT KUMAR
    Apr 06, 2017 at 09:00 PM

    try this.

    = If ([Modifications]>[Purchased] in ([Order ID])) Then "YES" Else "NO" ]

    Add comment
    10|10000 characters needed characters exceeded

    • Chuck M
      Apr 06, 2017 at 10:48 PM

      Hi amit,

      I did that and I got the same result as the modified column as I have now.

      I need to somehow filter line 1 out completely.

      can we do max (modifications) in order id or something like that?

      thanks