Skip to Content
0
Former Member
Aug 14, 2013 at 08:19 AM

SQ01: add more than 3 conditions to calculation of local field?

976 Views

Hi,

I'm creating a query report in transaction SQ01, and I have a couple of local fields to include. One of these fields is to be a text field that groups employees according to their age.

There are 5 groups in total: <25y, 25-34y, 35-44y, 45-54y and 55-64y.

Some other local fields have even more possible results.

However, in the complex calculation screen, it seems I can only define 3 conditions + 1 otherwise.

The + and - buttons only increase the amount of input lines for a certain selected condition or formula, but I don't know how to add additional conditions, if this is actually possible. Although when I look at the generated code, there's no reason why it shouldn't be...

Does anyone know the solution to this? And if it's not possible, what would be a possible workaround? I can't really add the field to the infoset, because it's value is calculated from the date entered in the selection-screen. Unless I can use LDB fields in an infoset somehow?

Thanks!!