In Report Studio, a decimal value field is adding up when there are multiple rows in the report...I can change the aggregate from Auto to None to stop this from happening, but I was wondering...is there some way to change the items in the Model??? The end users will consistently forget to change the aggregate to none when creating reports.
Right now, the table field in the modle is set to Usage: Fact and Regular Aggregate: Unsupported...the field type is a decimal.
Thanks!! :)
ekkk.nevermind, it wasn't changed in the TBL area.
got it, :)