Skip to Content

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

If / Else / Then Statement

I have a requirement where if a key figure falls within a range, it will be assigned a specific string value. For example:

Key Figure Value Bracket

0-100 B1

100-200 B2

200-300 B3

300-400 B4

400-500 B5


I'm attempting to avoid making back end changes to do this and would rather use Query Designer.

If I do this as an embedded object in a workbook instead (with if/then statements), I'd like to avoid using macros. I'd also have an issue with making the column length dynamic in order to fill the new column to the same length as the key figure column that it's referencing.

Former Member
Former Member replied

well, basically a virtual characteristic is a characteristic which value is picked up at query runtime

have a look at this document: []

it goes through all the necessary steps and has some explanation as well

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