Excel Forum

Expression Error

Faryal Shahabuddin

Active Member

Members

Forum Posts: 5

Member Since:
July 1, 2020

Offline

October 21, 2020 - 11:51 am

Hello All,

Can you please help me with this

Value.Divide ([#"Time Spent#(lf)on Job#(lf)(Hours)"], 7.25)

No Syntax error is detected

However,

Expression.Error: We cannot apply operator / to types Text and Number.
Details:
Operator=/
Left=72
Right=7.25

The type of input column is ANY

Following is the data used

Time Spent on Job(Hours)

400

100

Thanks in Advance.

Faryal

Catalin Bombea

Iasi, Romania

Member

Dashboards

Power Query

Power Pivot

Xtreme Pivot Tables

Excel for Decision Making

Excel for Finance

Excel Analysis Toolpak

Power BI

Excel

Word

Outlook

Excel Expert

Excel Customer Service

PowerPoint

Forum Posts: 1944

Member Since:
November 8, 2013

Offline

October 21, 2020 - 11:56 am

You can use

Value.Divide (Number.From([#"Time Spent#(lf)on Job#(lf)(Hours)"]), 7.25)

but better to format column as Integer or decimal before this operation, as it's more efficient to convert the column instead of converting row by row.

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online:

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Catalin Bombea: 1944

SunnyKow: 1432

Anders Sehlstedt: 956

Purfleet: 415

Hans Hallebeek: 377

Frans Visser: 351

David_Ng: 318

lea cohen: 248

Jessica Stewart: 219

A.Maurizio: 216

Newest Members:

Techia Braveboy

Charles Buchanan

Tiago Braga

Rehan Baig

Fred HORVATH

Silke Schmidt

Stuart Barr

Amelia Nolte

David Wier

T P Collins

Forum Stats:

Groups: 3

Forums: 25

Topics: 7154

Posts: 31382

Member Stats:

Guest Posters: 50

Members: 34655

Moderators: 2

Admins: 3

Administrators: Mynda Treacy, Philip Treacy, Jessica

Moderators: Velouria, Riny van Eekelen

Expression Error|Power Query|Excel Forum|My Online Training Hub