Max/Min/Avg for straight table

[anisha_nan]

Hi ,

I want Max/Min/Avg each description wise and tool wise.

Please find the attached data set of it.

Regards

[bharathadde]

Please find the attachment

Minimum Rate by ToolName

=Min(Total <ToolName>Rate)

Minimum Rate by Description1

=Min(Total <Description1>Rate)

Maximum Rate by ToolName

=Max(Total <ToolName>Rate)

Maximum Rate by ToolName

=Max(Total <Description1>Rate)

Average Rate by ToolName

=Avg(Total <ToolName>Rate)

Average Rate by Description1

=Avg(Total <Description1>Rate)

Hope this helps you 🙂

[anisha_nan]

Hi,

Thanks for the quick response.

I want to min/max/avg of rate at description 1 level.

why we are using total in this not clear?

Regards

[bharathadde]

I'm not sure what exactly you want as output.

Can you send me sample output for the data I created on the app.