why my sum function does not work properly ? - InfoPath Dev
in

InfoPath Dev

why my sum function does not work properly ?

Last post 11-20-2010 01:47 AM by milko. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-19-2010 07:48 AM

    • milko
    • Top 500 Contributor
    • Joined on 11-12-2010
    • Posts 28

    why my sum function does not work properly ?

    i dont know why the function inside the first qta field result in a wrong value: the function report a value of 48 instead 56.

    formula must be the result of the sum of all occurrence of tot_pagine_giornale (decreased of 40) inside the repeated section <data> (inside Data Connection "Fogliazione_GDV..."). all filtered by value <anno> and <mese> (main data source) (and valore_giorno != "lunedi" but the xml contains only saturday and sunday).

    the formula that should be corrected:
    somma(valutazione(data[valore_anno = current()/../../../../anno and valore_mese = current()/../../../../mese and valore_giorno != "lunedi"]; 'xdXDocument:GetDOM("Fogliazioni_GDV_con_mese_e_giorno")/tutto/date/data/dati_fogliazione/tot_pagine_giornale/valore - 40'))

    could you please check the zip attacched ?

    tvm, milko

  • 11-19-2010 11:03 AM In reply to

    • milko
    • Top 500 Contributor
    • Joined on 11-12-2010
    • Posts 28

    Re: why my sum function does not work properly ?

    infopath remembers the first occurrence and sum for the next.
    why eval does not do his job ?

  • 11-20-2010 01:47 AM In reply to

    • milko
    • Top 500 Contributor
    • Joined on 11-12-2010
    • Posts 28

    Re: why my sum function does not work properly ?

    dont worry, i solved :-)
    it was a mistake to approach the problem

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.