Sum values without activating the Sum in blueprint
Best Answer
-
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.
2
Answers
-
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
0 -
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
0