cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mobcdi Regular Visitor
Regular Visitor

Custom Column Help: Literal expected

Hi all,

 

I'm trying to create a custom column but I can't seem to get the formula right. I get the message literal value expected.

 

Any idea where I'm going wrong? 

 

if ([Column] >= 6.1 && [Column] <= 7.0) then “Value1"
else if [Column] >= 4.78 and [Column] <= 4.99 
then “Value2”
else if [Column] >= 3.21 and [Column] <= 3.5
then “Value3”
else if [Column] >= 1.4 and [Column] <= 3.20
then “Value4”
else “”
1 ACCEPTED SOLUTION

Accepted Solutions
mobcdi Regular Visitor
Regular Visitor

Re: Custom Column Help: Literal expected

Got it working. Think it was a case of quotes in the wrong places

 

if [Column]>= 6.1 and [Column] <=7.0 then "Value1" else if [Column] >= 4.78 and [Column] <= 4.99
then "Value2"
else if [Column] >= 3.21 and [Column]<= 3.5 
then "Value3"
else if [Column]>= 1.4 and [Column] <= 3.20
then "Value4"
else null

View solution in original post

3 REPLIES 3
Gordonlilj Established Member
Established Member

Re: Custom Column Help: Literal expected

Hi,

 

Try using and instead of &&

 

mobcdi Regular Visitor
Regular Visitor

Re: Custom Column Help: Literal expected

Hi 

I tried it with And instead of && but it was tagging the error as being just before the 1st then

mobcdi Regular Visitor
Regular Visitor

Re: Custom Column Help: Literal expected

Got it working. Think it was a case of quotes in the wrong places

 

if [Column]>= 6.1 and [Column] <=7.0 then "Value1" else if [Column] >= 4.78 and [Column] <= 4.99
then "Value2"
else if [Column] >= 3.21 and [Column]<= 3.5 
then "Value3"
else if [Column]>= 1.4 and [Column] <= 3.20
then "Value4"
else null

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 211 members 2,416 guests
Please welcome our newest community members: