## Forum Discussion

StephenJackson

Qrew Member

Hi Matt,

Thanks for your help!!

Your solution is still gives me an error where it says "Expecting number but found text" if the Report formula is a Formula - Numeric.

Or if I change it to Formula - Text, it'll only summarize by Distinct Count in the Summarize Data section.

Any ideas?

It

------------------------------

Stephen Jackson

------------------------------

Thanks for your help!!

Your solution is still gives me an error where it says "Expecting number but found text" if the Report formula is a Formula - Numeric.

Or if I change it to Formula - Text, it'll only summarize by Distinct Count in the Summarize Data section.

Any ideas?

It

------------------------------

Stephen Jackson

------------------------------

MattHardy

3 years agoQrew Trainee

Unfortunately, I misunderstood your original question and can't offer any more suggestions. Hopefully, someone else comes along with an answer for you.

------------------------------

Matt Hardy

------------------------------

------------------------------

Matt Hardy

------------------------------

- MarkShnier__You3 years agoQrew LegendStephen,

Did you try simply setting the format of your Summary Formula

### Step 2: Write summary formulas

Use your variables as you would normally use fields. For example, an Income formula might be "[Revenue (tot)] - [Expense (tot)]".

**Summary Formula 1 Numeric - Currency**[Invoice Amount (tot)] / [Number of Time Records]

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------