pengage
Forum Replies Created
-
ah, I need the age to 4 decimal places and dividing days by 365.25 is causing rounding errors
Sorry, hopefully a quick one – I can see on the WordPress blurb (https://wordpress.com/plugins/calculated-fields-form) the 7th paragraph says the plug in has age calculations as part of the Date operations m- I’ve not been able to find that formula, can you tell me where it is, please?
Thank you, it’s a lot more complicated – there are 12 dates when those people reach State Pension Age, so the age itself has 365 variations .
I have formulae that now work with 67 fields involved!
Thank you, it’s a lot more complicated than that but it’s where I started.
I find it easier to stick with the functions you’ve already defined, and also need other people to be able to understand/amend the formulae if I’m not around, so avoiding separate functions – the closer I can keep it to Excel, the easier for others.
Thanks, it’s an occupational pension calculator that needs the UK State Pension age, which is a ridiculously difficult to compute number for dates of birth in 1977 to 1978, to work out the last 31 March before that date.
So, I need to use IF functions to get the State Pension age and then the last 31 March.
The form’s here: https://pengage.co.uk/?cff-form=20 but I may have revoked your admin access since you last helped.
DELETED
- This reply was modified 10 months, 1 week ago by pengage.
Oh, thank you, now an idiot question – where do I put “Date(fieldname1, fieldname2-1, fiedname3)” and then be able to use that date in calculated fields, please?
Thanks – I’ll stick with the concatenate, just seems counter-intuitive to turn it into a text field to turn it back into a data field, but it works 🙂
Forum: Plugins
In reply to: [Calculated Fields Form] Number DS not usable in equationsThere’s no option to upload the zip file?
Forum: Plugins
In reply to: [Calculated Fields Form] Number DS not usable in equationsThankyou. The form is https://pengage.co.uk/?cff-form=11
For example, fieldname96 is one of the Number DS fields, fieldname101 is a Calculated Field that’s literally fieldname96, fieldname102 is PREC(fieldname24*fieldname96,4).
At the moment I’ve had to add additional Number fields that are the actual percentages needed so the equations work.
Forum: Plugins
In reply to: [Calculated Fields Form] wrong form appears on the public siteThanks @codepeople2, I’ll go back to emailing.
Forum: Plugins
In reply to: [Calculated Fields Form] wrong form appears on the public site@codepeople2 I’ll need to get our support people to look at the cache as we’ve been advised to use it. The forms were working fine until a week or so ago, around the same time that the registration box at the top of the CFF page keeps asking me to register (we have the Developer version) which has been verified. Could the two things be linked?
Forum: Plugins
In reply to: [Calculated Fields Form] wrong form appears on the public site@codepeople2 Top form is the i-frame without elementor/astra theme colours formatting, only the hard coding of the background colour.
The second is the normal not-i-frame version which shows the right colour formatting but the wrong calculations.
But the screen shot images won’t load.
- This reply was modified 11 months, 2 weeks ago by pengage.
Forum: Plugins
In reply to: [Calculated Fields Form] wrong form appears on the public siteI have the same issue – the i-frame strips out all the elementor/Astra theme formatting but does load the right form. So it’s not a good solution.
Without the i-frame the calculations aren’t working properly but the formatting works.