Why conditional formatting calculation isn't working?

  • CliqueDM
    Asked on March 20, 2018 at 10:22 PM

    I have entered some conditional formatting for my form - A calculation to be added to the results section of my form.


    For some reason the calculations I have completed are not working.


    can you please assist

  • Nik_C
    Replied on March 21, 2018 at 4:13 AM

    I checked your form, but I'm not sure what should be the calculation there since these conditions are not good:

    1521619757Screen Shot 2018 03 21 at 9 Screenshot 10

    You have multiply sign and .25, that cannot work in that way, you have to have field or value that will multiply that number:

    1521619881Screen Shot 2018 03 21 at 9 Screenshot 21

    So, either add a field that will multiply, or add a number.

    Let us know if you have any further questions.

    Thank you!

  • CliqueDM
    Replied on March 21, 2018 at 9:43 PM
    So I'm looking to multiply the answer that is filled into the field
    "Desired monthly Revenue" x 25% to give the answer in "Required ad spend"
    field.
    AND I'm also doing the exact same for "average sale value" field answer x
    25% to give the answer in "cost per sale"
    What should be the formatting for this calculation then?
    *Kristin McDonnell*
    *Director*
    *P: *+61 404395392
    *E: *kristin@luxesocial.com.au
    *W: *www.luxedigitalmarketing.com
    ...
  • Nik_C
    Replied on March 22, 2018 at 2:57 AM

    Thank you for additional information.

    Here is what you have to do:

    1521701812screencast Screenshot 10

    (I did the above in your form already)

    Please check and let us know how it worked.

    Thank you!

  • CliqueDM
    Replied on March 27, 2018 at 9:43 PM
    Hi there,
    so i have followed the video instructions added in the previous message and
    I'm now getting this as a calculation answer - please see screenshot
    *Kristin McDonnell*
    *Director*
    *P: *+61 404395392
    *E: *kristin@luxesocial.com.au
    *W: *www.luxedigitalmarketing.com
    ...
  • Nik_C
    Replied on March 28, 2018 at 1:36 AM

    I'm afraid we didn't receive your screenshot.

    But I checked your conditions, and there was an error in one of them:

    1522215339Screen Shot 2018 03 28 at 7 Screenshot 10

    I corrected that and tested, the form should be working fine.

    Let us know how it worked for you.

    Thank you!

  • Nik_C
    Replied on March 28, 2018 at 1:36 AM

    I'm afraid we didn't receive your screenshot.

    But I checked your conditions, and there was an error in one of them:

    1522215339Screen Shot 2018 03 28 at 7 Screenshot 10

    I corrected that and tested, the form should be working fine.

    Let us know how it worked for you.

    Thank you!

  • CliqueDM
    Replied on March 28, 2018 at 6:43 AM
    thank you so much!!!!! I'll go and check now!
    *Kristin McDonnell*
    *Director*
    *P: *+61 404395392
    *E: *kristin@luxesocial.com.au
    *W: *www.luxedigitalmarketing.com
    ...