0 Replies Latest reply: Nov 7, 2011 3:50 PM by Haider Al-Seaidy RSS

    Help with expression

       

      Hi,

       

      I’m struggling with a problem that seems a little more tricky than initially thought.

       

      My customer publishes articles on a regular basis. Their customers can login to a portal and download these published articles, with all downloads recorded in a table.

       

      The calculation I’m trying to produce should be able to evaluate 2 articles at a time (the one being evaluated and the previous one) and work out whether the contact download the first AND the second of the two evaluated articles. If this is true, this should count as 1.

       

      I have produce the figure required below – however with only a single contact highlighted at a time. I need to aggregate the required expression across all contacts which I have struggled to do. To be clear, if another contact had dowloaded Stories 1 & 2, I would expect to see 2 on the Story 2 record to show that 2 contacts had downloaded Stories 1 & 2.

       

       

      Contact

      Article

      DownloadCount

      The required value I want is

      Explanation

      Haider

      Story 1

      1

      0

      First Article - nothing to compare against prior

      Haider

      Story 2

      1

      1

      User download Story 1 And Story 2 - this needs to be   counted

      Haider

      Story 3

      1

      1

      User download Story 2 And Story 3 - this needs to be   counted

      Haider

      Story 4

      0

      0

      User download Story 3 But Not 4 - this needs to be ignored

      Haider

      Story 5

      1

      0

      User download Story 5 But Not 4 - this needs to be ignored

      Haider

      Story 6

      1

      1

      User downloaded Story 5 And Story 6 - this needs to be   counted

       

      To make things a little more tricky, I need to the table to always show all articles, even if one has 0 downloads.

       

      Example app and data attached. Thanks - Haider