Issue with formula

Hello, Franck,
 
Thank you for providing JSFiddle examples for reference.
 
In the JSFiddles, we noticed that you are creating a new calculated measure using an existing uniqueName - measure_5:

// The dataset:
[
 {
   dimension_0: 'ma pharmacie',
   dimension_1: undefined,
   Fidélité: '',
   measure_3: 23990,
   measure_4: 4976,
   measure_5: 26.17
 },
 ...
]


// The calculated measure:
{
  uniqueName: "measure_5",
  caption: "Quantité vendue result",
  formula: "(sum('measure_4')/(sum('measure_3')-sum('measure_4')))*100)"
}

This seems to be causing the issue since each measure should have its own unique uniqueName. With this in mind, we suggest providing a different uniqueName for the new calculated measure, for example:

// The dataset:
[
 {
   dimension_0: 'ma pharmacie',
   dimension_1: undefined,
   Fidélité: '',
   measure_3: 23990,
   measure_4: 4976,
   measure_5: 26.17
 },
 ...
]


// The calculated measure:
{
uniqueName: "measure_6",
caption: "Quantité vendue result",
formula: "(sum('measure_4')/(sum('measure_3')-sum('measure_4')))*100)"
}

Afterward, the formula should work correctly. Here is a modified version of the JSFiddle for reference: https://jsfiddle.net/flexmonster/okbm1tqw/.
 
Please let us know if this works.
 
Kind regards,
Vera

Hello, Franck,
 
Thank you for your reply.
 
As we see in 2.4, there was some sort of backdoor that allowed to override an existing field in the dataset by assigning its uniqueName to a calculated measure. However, this is not the expected behavior, and in the later versions of Flexmonster, this has been fixed. Therefore, a new uniqueName should be used when creating a calculated measure.
 
We hope this helps. Feel free to reach out if other questions arise.
 
Kind regards,
Vera