summaries in report

Julien Lopez

Hi

i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?)

here is what it looks like:

thank you

Paul Newcome

It looks like it is a text value which can't be used for Min and Max. You'll need to wrap the formula in a VALUE function to output usable numbers.

Julien Lopez

thank for the answers. so, the formula return a number. i've tried to add the function VALUE at the beginning but didn't change anything. how to return a formula to a text value?

Leibel S

@Julien Lopez

It is possible the End time formula is returning a text not a value?

Paul Newcome

It looks like it is a text value which can't be used for Min and Max. You'll need to wrap the formula in a VALUE function to output usable numbers.

Julien Lopez

thank for the answers. so, the formula return a number. i've tried to add the function VALUE at the beginning but didn't change anything. how to return a formula to a text value?

Julien Lopez

oh! my bad, just realize it works with VALUE function!! thank you all