Any way to calculate two field on the report module

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi,

Can someone help me to figure out anyways to calculate two different fields on the report detail view.

ex: I have various member types
I have to get the total number of member types
Also, I have to get the number of assigned articles to each member’s category.
Finally, I have to get the multiplication result of member count and * number of articles assigned.

Member Type : A
Number of Type A Members: 108
Number of Assigned articles: 3
I want to get the result as : 324

is it possible from suitecrm report module?

Report field calculations
Report field calculations1613×171 12.2 KB

2

Not sure if this can be accomplished with out modifying the code on that module.

There is a module called Advanced Reports by @mvnrsa. With that you can create your custom queries and view the reports from SuiteCRM. Take a look here: https://mjvn.com/index.php/2018/suitecrm-advanced-reports/