Calculations based on formula results rather than direct custom fields values

  • Resolved Luis Leal

    (@luis-leal)


    6 years, 3 months ago

    Greetings.

    I wonder if it is possible to create the following scenario:
    Variables to use:
    – A
    – X
    – Y
    – Z
    Constants to use:
    – d
    Formulas to use:
    – First
    – Second
    – Third

    1. If the result of the operation (X*Y*Z)/d is greater than A then First formula applies.
    2. If A is greater than the result of the operation (X*Y*Z)/d then Second formula applies.
    3. If A is equal to the result of the operation (X*Y*Z)/d then Third formula applies.

    For what I’ve understood this is possible, but I’ve found examples using only direct custom field values to trigger a formula usage.

    • I’d like some guidance about it and know if this is actually possible or not.
    • Also I’d like to know if this is not possibe in the community version and is only possible in the proprietary version
    • I’d like to know if this example I use is not possible at all
    • And Finally I’d like to know about grouping operators such as parenthesis () and scope operators such as braces {}, and its use within the formulas

    Thank you very much.

    • This topic was modified 6 years, 3 months ago by Luis Leal.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Luis Leal

    (@luis-leal)

    Sorry, the title should be <b>”Calculations based on formula results rather than direct custom post type object values”</b> But the restrictions of the platform www.remarpro.com doesn’t allow a longer title nor modification after moderation.

    I am aware that probably scope operators will not work since the custom post type object variables are declared through that.

    But still wondering, is it possible to achieve that?

    Thank you.

    • This reply was modified 6 years, 3 months ago by Luis Leal. Reason: Please contact me at [email protected] it is very urgent and I must comment to my client for they purchase the proprietary plugin in case it is possible to handle the requirements. I'm sorry for the insistence
    • This reply was modified 6 years, 3 months ago by Luis Leal.
    Plugin Author moomooagency

    (@moomooagency)

    Hi,

    No, it is not possible directly, unless you are very strong in maths and able to describe it mathematically somehow.

    Thread Starter Luis Leal

    (@luis-leal)

    Thank you for the answer.
    It looks like I’ll have to make a custom made solution.

    Have a terrific day.

    Plugin Author moomooagency

    (@moomooagency)

    For instance, you can create a NOV N1 with formula like max((X*Y*Z)/d,A) and then your N1 will be equal to the larger value from these two, right? But what then?.. hm-m… You can create N2 with formula like N1/A and if it is equal 1 then larger value is A, right? It is something already ?? Ok, what is next? ….. Aha! You may use formula conditional logic now and create a rule so that when N2 equal 1 then formula 2, else formula 1.

    Ok, what about formula 3? Hm-m… I don’t know… maybe create NOV N3 with formula like N1/((X*Y*Z)/d) and also check if it is 1 and so on? Is it a solution, what do you think?

    Parenthesis are used in the same way as in the maths – they give priority in a calculation for certain parts, as you need them to.
    Curly braces are used solely to define variables in formulas.

    Plugin Author moomooagency

    (@moomooagency)

    Check my second reply, it may be a solution for you. ?? Well, at least it looks like that.

    Thread Starter Luis Leal

    (@luis-leal)

    Now, THAT’S AMAZING!!!

    I’ll give you updates about this.

    Thank you very much. ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Calculations based on formula results rather than direct custom fields values’ is closed to new replies.