• Registered: 2014-10-10
  • Posts: 156

Topic: Convert Drop Down rating into Number

Sir,

I want to convert Drop Down rating into Number.

that is

Excellent  = 100
Good = 50
Bad = 10

how can we show, using calculate field,
I want to show data
as Name then Rating and then Rating No

Please see attach file.
Regards
Nitin Ingale

Post's attachments

Attachment icon Rating into Number.rar 3.84 kb, 311 downloads since 2017-05-17 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,687

Re: Convert Drop Down rating into Number

Hi Nitin,
Is this the sort of thing that you need?  (see attached)
Regards,
Derek.

Post's attachments

Attachment icon Rating into Number.zip 336.88 kb, 344 downloads since 2017-05-17 

  • Registered: 2017-04-22
  • Posts: 46

Re: Convert Drop Down rating into Number

Enter this to calculated field

(Case when ranking = 'Excellent' then '100'
      when ranking = 'Good' then '50'       
      when ranking = 'Bad' then '10'
end)