locked
CRM 2015 Online Calculated fields RRS feed

  • Question

  • Hi, I need a Help.

    Field A: Option set  (Percentage value)

    Field B: Option set (Percentage value)

    Field C = Field A * B

    Field D = Field C * Amount (Currency)

    Can We achieve this using Calculated fields?  I have created Option set as calculated fields.

    Please let me know

    Regards,

    Vinod

    Tuesday, September 8, 2015 7:15 PM

All replies

  • I'm not sure the calculated field approach will work like you want using Option Sets.  An Option Set consists of a label and matching integer value of that option.

    I haven't tried it, but my guess is that it will fail.

    You may want to try using the number type fields like decimal number to hold the percentage values.

    If you want to stay with using the Option Set approach, you may have to resort to jscript and on change event.  Then you can take the label from the Option Set and convert it to a decimal number for the calculation.


    Jason Peterson

    Tuesday, September 8, 2015 9:22 PM
  • Hi,

    I dont think it will actually take option set text and calculate things.

    Better way to do it in plugin or javascript. If you still want to work with calculated fields, Create 2 more attributes of integer/decimal and copy the selected option set text and use that attribute.

    Thank you,


    Thank you, Sreeni Pavalla Please Vote as Helpful and Mark As Answer if it helped you. Blog: https://sreenipavalla.wordpress.com/

    Thursday, September 10, 2015 10:57 PM