Sum values without activating the Sum in blueprint

tompatrick.ting

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

pyrypeura

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

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

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