Get Free Trial

Calculated values

Answered
Artsem asked on July 5, 2021

Hello,
I found a small problem. When was added calculated value without name field and then it was deleted number 1 in the input field(formula #1 -> formula#), then all subsequent fields have a name: formula #NaN

Attachments:
Capture.PNG

7 answers

Public
Vera Didenko Vera Didenko Flexmonster July 6, 2021

Hello, Artsem,
 
Thank you for reporting this issue to us.
 
Our team will provide the fix with the ETA 26th of July.
 
In the meantime, feel free to reach out if additional questions arise.
 
Kind regards,
Vera

Public
Vera Didenko Vera Didenko Flexmonster July 27, 2021

Hello, Artsem,
 
We are happy to inform you that the issue with calculated values naming was fixed.
 
This is available in the latest (2.9.4) version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component. Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please let us know if everything works fine for you.
 
Kind regards,
Vera

Public
Vera Didenko Vera Didenko Flexmonster August 9, 2021

Hello, Artsem,
 
How are you?
 
We are wondering if you had a chance to check out our latest fix. Does calculated values’ naming work fine for you?
 
We would be grateful for your feedback.
 
Kind regards,
Vera

Public
Artsem August 10, 2021

Hello Vera,

We aren’t updated to the last version.
Could you provide me with more details about addCalculatedMeasures. If I use this functional, whether the calculated values’ namings ​​will work there.
Best regards,
Artsem

Public
Vera Didenko Vera Didenko Flexmonster August 10, 2021

Hello, Artsem,
 
Thank you for your reply.
 
Yes, you can add new calculated measures through the addCaclulatedMeasure() API call and specify the new name for the calculated value via the uniqueName and caption properties.
We have a detailed tutorial for guidance: https://www.flexmonster.com/api/addcalculatedmeasure/.
Also, you are welcome to check out an example on JSFiddle.
 
We hope this helps.
Feel free to reach out should further questions arise.
 
Kind regards,
Vera

Public
Artsem August 10, 2021

Thanks for your answer.

But I want to know addCaclulatedMeasure() to provide to add “Formula #1” automatically if I leave an empty name

Public
Vera Didenko Vera Didenko Flexmonster August 11, 2021

Hello, Artsem,
 
Thank you for your question.
 
Please note that you need to provide a name when creating calculated measures via the addCaclulatedMeasure() API call.
For example:

let measure = {
formula: 'sum("Quantity")/count("Quantity")',
uniqueName: "Formula #1",
active: true
};

pivot.addCalculatedMeasure(measure);

 
You are welcome to contact us if additional questions arise.
 
Kind regards,
Vera

Please login or Register to Submit Answer