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

Dynamically adding formua to column

Hi

I have 2 expansions in ROWS - Account, Project

1 Expansion in COLUMN - TIME

and a third column that has a forumula in first row of second column

Time F1 (Foruml Column)

Account Project

I want the formula to be copied as after i execute the EXPAND ALL. at the moment i get 100 rows but formula is only in the first row.

Please tell me how to copy formula so that if there are 100 rows after execution, 100 formulas are filled correspondingly.

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2011 at 12:04 AM

    Hi Merc

    To get a formula to copy down it needs to be "inside" your evdre report.

    So I with your example you currently have a straight forward expansion with the last thing being a formula. If you adjust your retrieval so that there is a second retrieve section and you can have the formula in the blank in the middle.

    For instance your columns will now be "2010.TOTAL,2012.TOTAL|" which might be in the range "I10:J10,L10:M10"

    When you run this you have a blank column of K were your formula goes and column L and M will all hide as there is no data for them

    Regards

    Jason

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2011 at 08:18 PM

    Hi,

    You select the cell where the formula is working and drag it down manually till the 100th row .

    It will copy the formula to all the cells till the end.And then when you refresh your formula should work along with

    the entries in the report .Hope this helps.

    Sanjeev

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2011 at 02:32 AM

    Hi,

    If you have a content in the first row, it should have been copied till the last row; since you have a row expansion. However, this will happen only if the column is included in the colkeyrange.

    I understand that this is just a formula column, and doest not have any member as the key, but still you can include this in the colkeyrange.

    Hope this helps.

    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.