Nexel - Calculation

Jan Pettersen
Jan Pettersen Customer
Fourth Anniversary 5 Up Votes Photogenic 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, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    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
    Fourth Anniversary 5 Up Votes Photogenic First Comment
    edited November 2020
    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, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 2020
    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
    Second Anniversary First Comment Photogenic
    edited January 2021
    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
    Fourth Anniversary 5 Up Votes Photogenic First Comment
    edited January 2021

    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