What is the usage of...
Try to set it to attribute.
Not sure what you mean. All of this is happening in a report, not FM.
Calendar Days in a Lab is computed based on dates using _days_between. Detail Aggregation = Summary Aggregation = Total. But that probably doesn't matter since there will be only one [Calendar Days in a Lab] for each [MATSLabNumberNumeric]
MATSLabNumberNumeric is cast to an
int to eliminate leading zeros and for sorting. It is based on MATS Lab Number, which is an attribute = *Aggregation = none.
Regarding the values:
Yes, but 90, 91, and 92 all appear even though they all have the same value.
As I said, using the full MATS Lab Number functions fine. But that's not what the reader wants to see. They only want the sequence number, not the entire inventory code.
But thank you. You sparked a thought. If this is a typical request, why have the report developer do all of this work every time? I'll see if performing the calculation in the model will help.