Find mode from a number of tables 1

[rewob65]

Hi I have a report like this

Mon Tue Wed Thur Fri Sat Sun Answer

1 1 1 0 1 7 9 1
2 2 3 2 0 3 4 2
3 0 0 0 0 0 0 3
8 0 8 8 8 12 8 8

The days Mon Tue etc are the table name, I want to return the most frequent number used on Mon to Fri and have no idea how to create a mode across multiple tables.

I use 8.5.

 

[lupins46]

You can get the maximum of any set of values using this structure:

maximum([{table1.field1}, {table2.field1}, {table3.field1}])

 

[rewob65]

Sorry it is the mode average. In line 2 I want 2 however this may help

 

[lupins46]

Sorry I though you wanted the mode of the underlying values not the mode of the totals.
I don't think the Mode() function works on arrays.

 

[rewob65]

No mode average does not work the same.

It has helped a bit since in all except two circustances it works