Min(sum(field.value)) - nesting functions

• Eliza

  SSC Eights!

  Points: 967

  More actions

  December 25, 2013 at 5:44 pm

  #283928

  Hi All,

  I have a requirement where I need to find

  Minimum value

  Maximum vale

  Current vale.

  To find current value I am having to use the Sum() ssrs built in on a field and so in order to find the Min and Max I have to sum first and then use min/max.

  Trouble is SSRS doesn't appear to want me to do this generating an error message,

  Anyone have any ideas on how I came get around this please?

  Thank you

  Eliza

• pietlinden

  SSC Guru

  Points: 63517

  More actions

  December 25, 2013 at 9:31 pm

  #1675915

  I Grouped by X and then added a couple of columns and dropped the fields into the grid.

  =Min(Fields!X.Value,"DataSet1")

  =Max(Fields!X.Value,"DataSet1")

  No idea where SUM fits into this... I didn't need it.

  For grins I did "distance from Min"...

  Fields!X.Value-Min(Fields!X.Value,"DataSet1")

  If that doesn't fix the problem, describe it better. Or post a sample dataset, like this:

  SELECT 1 AS X

  UNION ALL

  SELECT 2 AS Expr1

  UNION ALL

  SELECT 3 AS Expr1

  UNION ALL

  SELECT 4 AS Expr1

  UNION ALL

  SELECT 5 AS Expr1

  Then at least people here will have a better idea how to help.