Nexel - Calculation

Jan Pettersen

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
------------------------------

Helmut Heimann

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

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

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

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

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

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