Hi,
I cannot seem to figure out how to declaratively format the result of an aggregate function using a GroupByExpression properly.
I have
GroupByExpression="Foo Name, avg(Total) [Average Days {0:0.00}]"
This shows both the formatted and unformatted value in the group header for Average Days.
Sample Result:
Name: Joe Smith; Average Days 30.47: 30.466666666666666666666666667
I can't seem to find anything online with this issue. I'm assuming I've done something wrong here.
Thanks,
ian
I cannot seem to figure out how to declaratively format the result of an aggregate function using a GroupByExpression properly.
I have
GroupByExpression="Foo Name, avg(Total) [Average Days {0:0.00}]"
This shows both the formatted and unformatted value in the group header for Average Days.
Sample Result:
Name: Joe Smith; Average Days 30.47: 30.466666666666666666666666667
I can't seem to find anything online with this issue. I'm assuming I've done something wrong here.
Thanks,
ian