Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

Calculate field value based on dimension level

Answered
Alessio asked on August 9, 2018

Hi,
I wonder if is possible to write a non-linear expression in formula for calculated field based on the hierarchy level with JSON datasource. For example, if I have Category and Product on rows I want to calculate Price like A+B on Category level and like C*F/2 on Product level. 
I know I can manage this behaviour in MDX with scopes but I have a flat JSON datasource.
Is there a way to do something like that with your library? 
 
Thank you,
 
Alessio

1 answer

Public
Iryna Kulchytska Flexmonster August 9, 2018

Hi Alessio,
 
Thank you for posting your question.
 
The component does not support the described calculated fields where the formula depends on the hierarchy level for flat JSON datasource.
Here is the article that describes what calculated fields are supported for JSON, CSV and OCSV data sources https://www.flexmonster.com/doc/calculated-values/
Unfortunately, it seems that our library cannot suggest the way to do this.
 
Kind regards,
Iryna
 

Please login or Register to Submit Answer