According to the online help for the MAX function:
max(dataset, column OR number, number…)
Finds and returns the maximum value in the given column of the given dataset, or the max value in a series of numbers specified as arguments. When looking up the max in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, zero is returned.
In the report designer I have a cell that is using the MAX function. If I use the following syntax I get a result:
@max(FlowTotalDataset[1].Diff_w201_14,FlowTotalDataset[2].Diff_w201_14)@
However, if I add another argument I get <N/A>:
@max(FlowTotalDataset[1].Diff_w201_14,FlowTotalDataset[2].Diff_w201_14,FlowTotalDataset[3].Diff_w201_14)@
Does anyone use this function in the Report designer? Is my syntax incorrect or is it just unable to process more than two arguments? I have a feeling I may be using this function incorrectly, as the examples in the help only show how to calculate the max value in a specified column or in a fixed series of numbers. I need to dynamically adjust the range that is evaluated by the MAX function based upon the day of a report. For example, today is the 23rd of the month. If I selected todays date for the report the MAX function should evaluate every day from the 1st until today. However, if I backtrack to the report for the 10th of the month the function should only evaluate values from the 10th back to the 1st day of the month. All the data is in the same column (Diff_w201_14), but the evaluated rows needs to change. Thanks for any help.
PJ Gonzales