Forum Discussion

artfulmunkeey's avatar
artfulmunkeey
Helper I
5 years ago
Solved

Column from column values

Hi all,   I have another problem that I cannot solve and wonder if the community can help.   I would like to create new columns based on the entries in the existing column 'Account Name' summing ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello @artfulmunkeey ,

    I don't quite understand why your 111222 account will be merged with account 100111 in the desired result.

    If you follow your table, the result may be this.

    Cost = IF([Account Name]="Cost",[Amount])
    Revenue = IF([Account Name]="Revenue",[Amount])

    6.png7.png

    More details can be found here.

    Best regards

    Stephen Tao

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello @artfulmunkeey ,

I don't quite understand why your 111222 account will be merged with account 100111 in the desired result.

If you follow your table, the result may be this.

Cost = IF([Account Name]="Cost",[Amount])
Revenue = IF([Account Name]="Revenue",[Amount])

6.png7.png

More details can be found here.

Best regards

Stephen Tao

If this post helps,then consider Accepting it as the solution to help other members find it faster.