Skip to Content
avatar image
Former Member

Countifs across webi merge continued... influence indicator not working

Amit Kumar kindly and skillfully answered a related question here:

https://answers.sap.com/questions/352011/how-do-i-make-a-countifs-across-business-objects-w.html

I, however, am experiencing a situation where the count is not working properly. For demonstration of the problem, I provide some sample data (scrubbed for confidentiality).

In the main table, the second row "Indicator" should show a value of 1, not 0 as it currently does. This is because there is at least one exam between the "Plan Date" and the "Relative Plan Date"--that is, the 8/20/2017 "Exam Date".

"Plan Date", "Relative Plan Date", and "Exam Date" are all detail variables, based on association with merged dimension "student_number".

Here is my main table:

 plan_stamp     Relative Plan Date     student_number     Indicator
 10/14/17       10/21/17               553422424          0
 8/19/17        8/26/17                553422424          0

The "Indicator" column has the following formula:

=If Sum(If([Exam Date]<=[Relative Plan Date] And ([Exam Date]>=[Plan Date])) Then 1 Else 0) > 0 Then 1 Else 0

The "Relative Plan Date" column has the following detail variable:

=RelativeDate(plan_stamp;7)

Here is the secondary exam table, which the main table is meant to count:

Student Number     Exam Grade Date     Exam Date
553422424          7/25/17             7/25/17
553422424          7/27/17             7/27/17
553422424          8/5/17              8/5/17
553422424          8/20/17             8/20/17
553422424          9/2/17              9/2/17
553422424          9/16/17             9/16/17
553422424          9/19/17             9/19/17
553422424          9/23/17             9/23/17
553422424          9/25/17             9/25/17
553422424          9/30/17             9/30/17
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers