How do I replace the IN-RANGES-OF null value default = '***-***' with something like 'NS'?

This message has been edited. Last edited by: Kerry,

quote:

IN-RANGES-OF null value default =

There is no such thing that I've ever seen.

A simple code example of what you are trying to do might help us help you.

TABLE FILE A_DETAIL
BY LOWEST A_DETAIL.A_DETAIL.RESPONSE_CD
BY LOWEST A_DETAIL.A_DETAIL.SCORE_NBR IN-RANGES-OF 50
ON TABLE NOTOTAL
END

Produces...

RESPONSE_CD SCORE_NBR
1 *** - ***
0 - 49
50 - 99
100 - 149
200 - 249
400 - 449
2 *** - ***
0 - 49
50 - 99
100 - 149
3 *** - ***

How do I get *** to be 'NS'?
Thanks

This is wierd, looks like the range has overflowed.

Have you determined what the source data is for SCORE_NBR for the **** - **** ?

Actually the request is not valid (but that looks like wrong output anyway)

Your request has to have something to apply the range to
for example

TABLE FILE CAR
SUM CNT.MODEL
BY LOWEST SEATS
BY LOWEST SALES IN-RANGES-OF 1000
ON TABLE NOTOTAL
END

It appears to be 7.7.0.2 specific as it works fine in earlier releases.

I would raise a case with IBI.

The really irritating thing is that it does not display the range step where no data exists.

I could simulate the **** with setting the size of the numeric to a smaller value, but not where it puts the *** at the first range.

Can you repro with one of the sample files ?

'*** - ***' is the default for when the source value is NULL. I could make a second pass. Over the result to convert the that string to 'NS' but I was wondering if there was more control over the IN-RANGES-OF function.

I don't believe there is a way to control it, apart from creating the ranges your self.