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

Admin

Forum Posts: 1807

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: Hans Hallebeek, John IM, Manjula Mangalmurti

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Lawrence Miu

Jo Saies

Paul Pritchard

Monique Roussouw

Keith Aul

Richard Dunks

Manjula Mangalmurti

Thomas Quidort

Jamie Preece

Bob Smith

Forum Stats:

Groups: 3

Forums: 24

Topics: 6192

Posts: 27150

Member Stats:

Guest Posters: 49

Members: 31848

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen