Sum values without activating the Sum in blueprint

tompatrick.ting
edited December 2022 in Modeling

Hi,

Is there a way i can get the total value in a list without activating the SUM in the line item blueprint?

I want to save the space so i want to use None in Summary but i need to get the total in another module where i don't have the list.

Thanks,

Tom

Best Answer

  • pyrypeura
    edited December 2022 Answer ✓

    Hi @tompatrick.ting

    Other option would be use a dummy list as total. Please see example with screenshots below.

    As starting point you would have your values in source module

    pyrypeura_0-1670227707978.png

    Next you would create a list called total and populate that with item called 'total item'. Then in properties module of list you want to sum up you would add line item called total formatted as total list and formula pointing to total item of that total list

    pyrypeura_2-1670227846147.png

    pyrypeura_1-1670227810459.png

    As last point in target module you can have this total list as dimension and sum values using this line item from properties module.

    pyrypeura_4-1670227905386.png

Comments

  • jagadishdash
    edited December 2022

    Hey @tompatrick.ting

    You can create another module with the parent List member as dimension and can refer from that module and it'll work as summery value.

    Hope it helps.

    Thanks,

    Jagadish Dash

  • tompatrick.ting
    edited December 2022

    Hi @jagadishdash ,

    Your suggestion to have a parent only member in another module means i will still need to set my source module summary to Sum ?

    Regards,

    Tom