Is Summary not dynamic?

Options
CommunityMember126793
CommunityMember126793 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Regular Contributor
in Extensibility

Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case..

CommunityMember126793_0-1656504148992.png

Note: The module is data module where all the data is imported through csv file.

Tagged:

Comments

  • CommunityMember126793
    CommunityMember126793 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Regular Contributor

    @rob_marshall are you saying to create same number of line items (in same or new module won't matter much) and then referenced them from the input line items?

    Apply Summary as SUM on those new line items.

    Apply filter on the module and formula line item's SUMMARY will change as per applied filter..

    Is it what you are recommending?

  • CommunityMember126793
    CommunityMember126793 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Regular Contributor

    Thanks @rob_marshall  for pouring in the solution but there is a caveat with the proposed solution i.e. Import module is dimensioned on a fairly large list (more than 500k) and an introduction of another (calc) module with 35+ line items will increase the model size exponentially which we don't wish to get into.

  • CommunityMember126793
    CommunityMember126793 Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Regular Contributor

    @rob_marshall sorry for turning up late!

    Search should be based on the Master Data, means user will select the value from list-type line item and that will be looked into SYS module and basis upon the list-items from SYSTEM module the CALC / REPORT modules will   be filtered.

    After applying this logic, the issue is that CALC / REPORT modules Summary line is not changing Summary value unless  CALC / REPORT modules has that Boolean check in line items. For reference:

     

    CALC module output: based upon filter only 2 lines are the result but Summary of each column is of all lines. 

    CommunityMember126793_0-1658211805815.png

    This (Summary calculation based on filtered data) sorts only if I apply the Boolean lineitem as a precheck in each line-item as shown below:

    CommunityMember126793_1-1658211974520.png

     

    But it is an issue, because if I want to refer this this CALC lineitem to in REPORT module then this source line-item data comes out only basis upon the filter (and not overall).

     

    Hope I am clear with my little long msg. 

    Kindly note, SYS module and CALC / REPORT modules share same granularity but SYS is not time based.

Categories