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
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.
well, basically a virtual characteristic is a characteristic which value is picked up at query runtime
have a look at this document: [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e051fda8-71a9-2a10-ac9e-8d17414a8c8c]
it goes through all the necessary steps and has some explanation as well