Hi ppl,
I built a data action in advanced formula last week which works properly. The data action just spread some cell values to other certain cells. But after the new release, the data action adds up the previous value with the new value.
FLOAT @weight FOREACH [d/KPIs] @weight = RESULTLOOKUP( [d/Counterparty] = "Supplier_1", [d/Year] = "201912", [d/Organizational_Unit = "BU_1") FOREACH [d/Organizational_Unit] FOREACH [d/Counterparty] IF RESULTLOOKUP( [d/KPIs] = "kpi1") != NULL THEN DATA() = @weight ENDIF ENDFOR ENDFOR ENDFOR
Does anyone have an idea why this piece of code will make the data action adds up old value and new value insteading write the weight directly in the cell ?
Thanks a lot!