Calculation based on multiple choice
I

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

Ninox Profile

Hi Ivor, 

Please use this, 

--------

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

--------

Screen Shot 2018-04-16 at 09.44.27

Regards,

Sakshi-Ninox Support

I

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 ?

 

Ninox Profile

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

I

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 %')

Ninox Profile

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

Ninox Profile

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

Reply