reyanntee

Hi,

Thanks, it works perfectly fine.

Regards,

Hi,

how do i round off the return value into 2 decimal places?

this is what i am using at the moment

(function(){
var f1=fieldname4, f2=fieldname77, f3=fieldname3, f4=fieldname6, f5=fieldname7;

if(!jQuery.isNumeric(f1)) f1 = f1.replace( /[^\d\.]/g, '').replace(/^\.+/, '').replace(/\.+$/, '');
if(!jQuery.isNumeric(f2)) f2 = f2.replace( /[^\d\.]/g, '').replace(/^\.+/, '').replace(/\.+$/, '');

return f1*1+f2*1+f3*1+f4*1+f5*1;
})()

Thanks,
Rey

• This reply was modified 8 years, 1 month ago by reyanntee.
• This reply was modified 8 years, 1 month ago by reyanntee.

Hi,

Thanks for the reply, just one more. Is it possible to add a shortcode inside the calculated fields form?

Thanks,
Rey

Hi, Just wanted to ask also how to ignore text value on the calculated field input.

Regards,
Rey

Hi,

Oh and this one too:

SUM(P16/O16)

Thanks so much

Hi,

I just wanted to know how do i solve this problem? on the calculated field?

(SUM(fieldname1))*(SUM(fieldname1))/(SUM(fieldname1))

Thanks & Regards,
Rey

HI,

Just wanted to know that when this equation is done
fieldname12+IF(fieldname2>10001,FLOOR(fieldname2/10000)*10000*0.01,fieldname2*0.01)

where fieldname12 is “currency sign” and fieldname2 is “value”, what can i add here to for example the result is below 100 like 65 it would display 100 instead of 65 and if it is above it would the the actual result.

Thanks,
Rey

How about the sign for $ not showing up when being chosen?

Thanks,
Rey

Hi,

Thank you that solved the problem big time.

Last 2 question and final if that would be alright is that when I am using the currency $ it doesn’t seem to show itself? Should i change the radio field to currency? if so how do i add multiple currency to choose from?

and lastly how do i use a validation for the Company URL and email? for example the email would be [email protected] and the website is https://www.yourwebsite.com, could i add something there to compare the two? so that if the last part of the email which is @yourwebsite.com is different from the company URL it would return an error?

I think this would be the last problem i am encountering, I would like to tell you that the client is very much pleased in buying the said software which does what they wanted.

Thanks so much for the support,
Rey

Hi,

So yep it’s working now but only when i choose the currency to $ but when i choose the currency for the ￡ pounds sign, it doesn’t seem to show up?

Regards,
Rey

Hi,

Sure it’s for a client i’m currently working at, the website link would be https://www.swifterm.com you can see it on the Calculation part.

Thanks,
Rey

Great,

It’s working now, thank you for the swift response.
Oh and another thing when using this equation:

fieldname12+fieldname10*51/100+3000

where fieldname12 is currency and fieldname10 is 3000 for example, the equation works until you divide it by 100 then the last part which is adding the 3000 results in

15303000

It just displays the two numbers and doesn’t seem to add it together which should result in 4530.

Thanks,
Rey

Hi,

I also have a question, How do i hide the 0 number when there is nothing being calculated? The problem is that 0 is being shown even if there is no calculation being done.

For example i have an optional result/calculation field which has this format
fieldname14*.51+fieldname14 where as fieldname14 is the value that is optional to add a number on it.

What i want is that if they don’t put anything there on the field instead of 0 being shown a blank field would be shown instead.

Thanks,
Rey

Hi,

Thanks for the quick reply, I forgot to tell you that the form works, But now I want to do something else, I was hoping you could help me out, you see on a calculated field when the value is zero I want to to show as empty or blank input result instead of displaying the number 0 here is my equation:
fieldname14*.51+fieldname14

I know i need to maybe use the if and else function? I just don’t know how to do it.

Best Regards.

Hi,

I’m having the same problem but I think mine would be simpler, I want to ask if you could help me out with my equation…

I’m currently using MS Excel equation as it looks to be working for the plugin, my equation is:

IF(fieldname2>10001,FLOOR(fieldname2,10000))*0.01

so the result should be rounded down to the nearest ten thousand then multiplied it by 0.01

Hoping to hear from you soon.
Thanks.