
1. Re: How to provide sums per line
Naveen B Aug 24, 2018 5:43 AM (in response to Jomi Lemmermann)Hi Jomi,
change your calculation like below
ZN(SUM([AmeAm1]))+ZN(SUM([AmeUrf]))+ZN(SUM([AmiAap]))+ZN(SUM([AmiAma]))+
ZN(SUM([Amn/Amh]))+ZN(SUM([AsdAdm]))+ZN(SUM([AsdAdm]))
+ZN(SUM([AsdAms]))+ZN(SUM([AshAmh]))+ZN(SUM([AshAshd]))
+ZN(SUM([AshAshi]))
Including all the measured values and padded with ZN
Hope this helps kindly mark this answer as correct or helpful so that it will help others
BR,
NB

2. Re: How to provide sums per line
Jomi Lemmermann Aug 24, 2018 6:01 AM (in response to Naveen B)Hello Naveen,
Thank you for your answer. This calculation now gives me the sum per column. So I get the sums for every funds.
I was actually looking for the sum per line, so the sum for every unit over all funds.
Despite this, your answer was helpful as well, as it solves my second Problem.
Thanks a lot so far,
Kind Regards,
J.


4. Re: How to provide sums per line
Okechukwu Ossai Aug 25, 2018 5:15 AM (in response to Jomi Lemmermann)Hi Jomi,
What you are looking for may require a separate calculation for each measure. This may become a bit clumsy. An alternative approach will be to pivot the data. This will depend on your data source. See attached workbook.
Step 1: Pivot your data
Step 2: Delete the old individual measures. Rename Pivot Field Names and Pivot Field Values to something more meaningful.
Step 3: Create calculated fields to sum the values per pivot field name and fondsname.
[Sum per Pivot Field Name]
{FIXED [Pivot Field Names]: SUM([Pivot Field Values])}
[Sum per Fondsname]
{FIXED [Fondsname]: SUM([Pivot Field Values])}
Notice that the Pivot Field Values and the calculations give you same result in the screenshots below. So, you won't need the calculations except you want to use the calculated fields for other purposes.
Hope this helps.
Ossai

Sum per Row_OO_v18.1.twbx 73.8 KB
