Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formula Grouping of Name Object

Hello - Kindly assist.

I have a formula - Trying to group some Name by my defined Name preferred and Group some Names together as well. See my formula below. The issue is - the query does not bring out the GROUP and TOTAL. Is it because I am calling it twice in the query?

The query only brings out the Name below:

CAT, BABOO, MIA.

However, the GROUP and TOTAL not coming up in the list - Note that the GROUP and TOTAL is to add up the Names that I already referenced in the formula. I need assistance to see the Name Object display. Thanks ALL

CAT

BABOO

MIA

GROUP

TOTAL

=If ([Name]InList("CMO");"CAT";If ([Name]InList ("BAT";"BABO"); "BABOO"; If([Name] InList("MIA"); "MIA"; If([Name] InList("BAT";"BABO";"CMO");"GROUP";If([Name]InList("CMO";"BAT";"BABOO";"MIA");"Total";[Name])))))

Not what you were looking for? View more on this topic or Ask a question