7 Replies Latest reply on Nov 22, 2016 6:16 AM by bikash rawal

sum/subtract rows/fields and and create computed column for the sum results

I have below table. I need to do the following:

(NPS = Promoter) - (NPS = Detractor) = 4 (63-59). Now I need this 4 or the results to be in the new calculated column or new table. Is it possible? It's simple in excel but doesn't seem here.

Message was edited by: bikash rawal

Message was edited by: bikash rawal

• 1. Re: sum/subtract rows/fields and and create computed column for the sum results

Hi , Try this :

Create a calculation like below :

{fixed : sum(if [Row Labels]='Promoter' OR [Row Labels]='Detractor') then 1 else 0 end}

Use this calculation in View.

• 2. Re: sum/subtract rows/fields and and create computed column for the sum results

Hi Hima,

Thanks for the quick response. That doesn't quite help. It giving identical value which is not right.

• 3. Re: sum/subtract rows/fields and and create computed column for the sum results

Hi Hima,

I have updated the question, please update if you have solution to this.

Thanks,

Bikash

• 4. Re: sum/subtract rows/fields and and create computed column for the sum results

I got the result but it's adding not subtracting.

• 5. Re: sum/subtract rows/fields and and create computed column for the sum results

Please attach sample workbook and Expected result as a screenshot in excel sheet !

• 6. Re: sum/subtract rows/fields and and create computed column for the sum results

Attached on the original post above. Pleas look into that. diff is the calculated field with; WINDOW_SUM(SUM(if [NPS]='Promoter' OR [NPS]='Detractor' THEN 1 ELSE 0 END)) formula.

It works doing something like sum([a])-sum([b]) but with referencing the corresponding field it doesn't looks to  be working.

Please go through the workbook and and let me know if any questions. I hope you get the solution to this.

• 7. Re: sum/subtract rows/fields and and create computed column for the sum results

You have attached twb file, so couldn't open your workbook .