0

Calculation based on multiple choice

HI I am trying to use a formula in a cell that is based on the selcetion of a multipe choice in another cell..   ie multiple choice could be a)5% or b)10%.....  from this,  in another cell I want to multiply a value based on the selection from the multiple choice... 

I can get it to work as long as I use a txt box but cant get the formula to recognise the multiple choice value

6 replies

null
    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi Ivor, 

    Please use this, 

    --------

    'Input Number' * number(chosen('Discount (%)')) / 100

    --------

    Screen Shot 2018-04-16 at 09.44.27

    Regards,

    Sakshi-Ninox Support

    • ivorwilkinson
    • 5 yrs ago
    • Reported - view

    Hi thanks for your feedback,  could you expalin a little more I stilll dont understand this formula

    where/what is the NUMBER before thr brackets 

    assume "input number" is the cell that I am trying to apply the discount to ?

    • Support
    • 5 yrs ago
    • Reported - view

    That "5" and "10" are the labels of the multiple choice fields are are handled an string. number() is used to convert them to - numbers.

    Birger

    • ivorwilkinson
    • 5 yrs ago
    • Reported - view

    thanks I now have the formula making the calculation at least but the calcualtion result is wrong (formula below)

    It is using the value from the multipe choice as opposed to the actual selection 

    for example 5% = 1 ,  10%=2  how do I make 5% = 5 and 10% = 10

     

    cost * number('Discount %')

    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi Ivor, 

    The formula is:

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

    Cost * number(chosen('Discount %')) / 100

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

    Please input only numbers in Multiple choice field, without the percenage symbol.

    Screen Shot 2018-04-17 at 13.02.58

    Regards,

    Sakshi-Ninox Support

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Make sure you are using a CHOICE field.. not a MULTIPLE CHOICE field..  number(chosen('MULTIPLE CHOICE")) always returns zero. 

Content aside

  • 5 yrs agoLast active
  • 6Replies
  • 3131Views