Cannot make totals from multiple repeaters

  • Resolved myerrorsandmysolutions

    (@myerrorsandmysolutions)


    3 years, 9 months ago

    Scenario:
    Repeater 1
    Repeater 2
    Calculated field to summarize totals from the two repeaters

    I configured the page and formula but the calculated field returns only the total of the first repeater on the page.

    If I change the order of the repeaters the page acts in the same way, totalize only the first one at the top of the page.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor hugreed

    (@hugreed)

    You have the same formulas for both repeaters, but the fields are different.

    Check your Calculation Formula for Repeater for the second repeater

    Thread Starter myerrorsandmysolutions

    (@myerrorsandmysolutions)

    Hi,

    Formulas are different.

    Repeater 1 name is:
    teglie_rettangolari
    The calculation formula for Repeater 1 is:
    %FIELD::field_larghezza%*%FIELD::field_altezza%*0.5

    Repeater 2 name is:
    teglie_quadrate
    The calculation formula for Repeater 2 is:
    (%FIELD::field_lato%^2)*0.5

    The calculated field for total has a formula:
    %FIELD::teglie_rettangolari%+%FIELD::teglie_quadrate%

    Please verify

    Plugin Contributor hugreed

    (@hugreed)

    Oh yes, I found it to be a bug. The fact is that the calculated repeater fields repeat the formula of the first repeater.
    https://prnt.sc/13u99y7

    We will make a release, including fixes for you soon, but not right now, in case you find something else, for which we will only be grateful to you.

    Thread Starter myerrorsandmysolutions

    (@myerrorsandmysolutions)

    Great, thanks

    Thread Starter myerrorsandmysolutions

    (@myerrorsandmysolutions)

    After 1.2.2 this seems working now.

    I had to rewrite some formulas because exponentials stopped working.

    Example:
    (%FIELD::lt%^2)*%FIELD::nq%*0.5
    does not work

    %FIELD::lt%*%FIELD::lt%*%FIELD::nq%*0.5
    works

    Please confirm if it works by design or if this is a bug.

    Plugin Contributor hugreed

    (@hugreed)

    For exponentiation use **.

    In your case it will be %FIELD::lt% ** 2

    Thread Starter myerrorsandmysolutions

    (@myerrorsandmysolutions)

    Perfect, it works, thank you.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Cannot make totals from multiple repeaters’ is closed to new replies.