Multiply Subgroup by -1

Question

Hello,I have two questions in below group and subgroup.1. How to multiply by -1 to some variables.&nbsp; For example&nbsp;&nbsp; &nbsp;Accounts Payable =&nbsp;Accounts Payable Amount MST&nbsp; *-12. How to rename total column. For example Total Current Liabilites insted of just total&nbsp;&nbsp;Liabilities and Equity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Group&nbsp; &nbsp; Current Liabilities&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SubGroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Accounts Payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; variables&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Accured Compensation&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Deb Short Term&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; total of subgroup&nbsp; &nbsp; Equity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Common Stock&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Retained Earnings&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;total of subgroup&nbsp; &nbsp; Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;total of group&nbsp; &nbsp;ThanksSmita

anonymous · Answer

sjoshi&nbsp;create a new calculated column to multiply by -1 and I dont think you can rename the total, you could create a new calculation called total for abc.

v-piga-msft · Answer

Hi&nbsp;sjoshi,
&nbsp;
Have you solved your problem?
&nbsp;
If you have solved, please&nbsp;always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
&nbsp;
If you still need help, please feel free to ask.
&nbsp;
Best Regards,
Cherry

Forum Discussion

Multiply Subgroup by -1

2 Replies

Related content

Index multiple subgroups

PowerQuery sort and index on subgroup

multiplier

Index by subgroups with repeated values

IF and Multiply