Nexel - Calculation

Options
Jan Pettersen
Jan Pettersen Customer
Photogenic First Anniversary First Comment
edited October 2020 in Platform
Hi,
I'm working with Nexel and have to data views in the screen.  The last one I'm using Nexel to hget a value from the first data view by having this formula =["Nettkapital;@f;*;*;Range.Vertical] and this works.  The main goal is to multiply the "Nettkapital" (Grid Capital) with 1.01.  This do noe work in my data view.  It works if i multiply with 1 or 2 but not 1.01? 
Could sombody help me an tell me what I'm doing wrong?

Br, Jan Pettersen

------------------------------
Jan Pettersen
Controller
Agder Energi AS
Norway
------------------------------
Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited November 2020
    Options
    Hi @Jan Pettersen,

    when you say it doesn't work with the factor 1.01, what's the result you see? Is the result zero or still the same value?
    Did you check that the result column should be displaying decimals?

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Jan Pettersen
    Jan Pettersen Customer
    Photogenic First Anniversary First Comment
    edited November 2020
    Options
    Hi,

    The result is blank (Null). And the column has 2 decimals.  When i multiply with 1 or 2 the result apears.  I found a soltion where i had a formula: [#Nettkapital;@f;*;*;Range.Vertical])/1)%)+[#Nettkapital;@b;*;*;Range.Vertical]

    And this is working

    Br, Jan

    ------------------------------
    Jan Pettersen
    Controller
    Agder Energi AS
    Norway
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited November 2020
    Options
    Hi Jan,

    great that you've found a solution. Nevertheless, I'd advise you to open a ticket with our support so that they can have a look into this.

    Kind Regards
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Virgile DEMOLLIENS
    Virgile DEMOLLIENS Active Partner
    First Comment First Anniversary Photogenic
    edited January 2021
    Options
    Hi Jan,

    Did you open a ticket related to this issue. Because I'm facing a similar issue and do not know what to do.

    Thanks !

    ------------------------------
    Virgile Demolliens
    Consultant Manager
    NEONN
    France
    ------------------------------
    -------------------------------------------
  • Jan Pettersen
    Jan Pettersen Customer
    Photogenic First Anniversary First Comment
    edited January 2021
    Options

    Hi,

     

    Since it worked with the % I did not send a ticket.  But it's a bug so I will send the ticket om Monday.

     

    Have a nice week end!

     

    Jan

    Sensitivity: Internal



    -------------------------------------------

Categories