Skip to Content

Analysis for Office overwriting Excel formula

Hi - I am using AO 2.4.1.2 and adding a column for an Excel formula. When I add the formula below, AO changes it when used (I hit enter).

Formula typed:

=IF(SUM($I$28:I28)<=80,"A",IF(SUM($I$28:I28)<=95,"B","C"))

Formula AO changes to:

=IF(SUM($I$28:$I$28)<=80,"A",IF(SUM($I$28:$I$28)<=95,"B","C"))

Any ideas on how to I can get this to stay as typed?

Kind regards,
Kelly

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 31, 2017 at 10:03 AM

    I think this is normal behaviour if you add the formuals in the are of AO crosstabs. That's the behaviour I have seen as I used this function last time.

    Add comment
    10|10000 characters needed characters exceeded

  • May 31, 2017 at 05:58 PM

    Kelly - interesting, I tried this with 2.5 and cannot replicate the issue. Hopefully 2.5 will be out soon.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2017 at 04:45 PM

    Hello

    I try this on Analysis 2.5 :

    - Column before

    - in this column i add the formula : = B2&C2

    Formula AO changes to: =$B$2&$C$2 on all rows, i can't change them.

    Any ideas ?

    Kind regards,

    Thierry

    Add comment
    10|10000 characters needed characters exceeded