We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

% of Grand Total Price vs % of Parent Row Total calculation

Answered
Janez asked on June 26, 2023

Hi,
I have a question why % of Grand Total Price vs % of Parent Row Total calculation is one time positive and other time negative when there are negative price values? I prepared an example https://jsfiddle.net/Janez231/hwunze6v/4/.
When I am using % of Grand Total there is always positive value even the price is negative. See atached files. Is this a bug or have some logic behind?
Thank you very much.
Janez
 
 
 

7 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster June 27, 2023

Hello, Janez!
 
Thank you for contacting us and for providing detailed examples of the case.
 
We agree that our calculations of percentages with negative values have some inconsistency. Our Development team would look into the described behavior and research possible solutions to unify the calculation of the percentage with negative values.

We will notify you about the results of the research on ETA July 24th.
 
Feel free to contact us in case of any other questions.
 
Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster July 25, 2023

Hello, Janez!
 
Hope you are doing well.
 
We are glad to inform you that the percentofparentrowtotal, percentofparentcolumntotal, percentofcolumn, and percentofrow aggregations now are consistent and always return a positive percent value.

The fix is included in the 2.9.56 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-56/.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please let us know if everything works well for you.
 
Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 1, 2023

Hello, Janez!

Hope you are having a great week.

Our team is wondering if you have some time to try the updated percent aggregations. Could you please let us know if everything is well?

Looking forward to hearing your feedback.

Kind regards,
Solomiia

Public
Janez August 1, 2023

I am on vacation and we will do review next week.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 1, 2023

Hello, Janez!

Thank you for getting back to us.

Your feedback is valuable to our team, so we will be waiting for the next updates on the case.

Wishing you a wonderful vacation.

Best regards,
Solomiia

Public
Janez August 7, 2023

I can confirm that now funcionality is now aligned and works as expected.
Thank you
Janez

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster August 7, 2023

Hello, Janez!

Thank you for your feedback.

We are glad to hear the updated percent aggregations work well for you.

Feel free to contact us in case of any other questions.

Kind regards,
Solomiia

Please login or Register to Submit Answer