Skip to Content
1
Jun 09, 2020 at 08:15 AM

Data Action does not work properly after the new release 20

140 Views

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!