Skip to Content

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

Different Excel formula in different columns of a local member row...

I have a need to use different (Excel) formulas in different columns in a local member row for a dynamic report. The layout looks like:

How do I achieve it using a local member formula? or otherwise.

loc1.PNG (9110 B)
Former Member
replied

Hi Coomar,

There is no general solution for all cases, but you can use Excel functions to determine the column:

=IF(COLUMN()=7,...,IF(COLUMN()=8,...,...

Vadim

1 View this answer in context

Helpful Answer

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