Skip to Content

While ... Do question

Hi,

I need to create a report with 30 columns (interval points) look like this.

Year 12 24 36 48 60.... 2000 2001

First interval point is based on a difference between two dates, the consequent points are the prior point + 12.  I did the manual way by creating 30 formula fields which works.  I am wonder if there's a more efficient way to handle this by using a while ... do loop or anything other functions.

Thank you for your help in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 22, 2015 at 12:39 AM

    Hi Gwendolin,

    You'd still need 30 formula fields - one for each column.

    A better alternative is to handle this in the database. You can then insert a crosstab on the report.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded