DataAction Calculation

[Bernardo_Santos1]

I have these data in a planning version that were copied from an Actual and Forecast version. I’m able to copy them correctly, but I have a dataAction that is supposed to calculate the percentage of the "Percentagem VB" measure, which should act on the VB value.
This is the formula I’m using:

MEMBERSET [d/Date] = (%TargetMonth%)
DATA([d/Measures] = "VB") = RESULTLOOKUP([d/Measures] = "VB", [d/Date] = %SourceMonth%, [d/Version] = %SourceVersion%) * (RESULTLOOKUP([d/Measures] = "perce_aumento_VB", [d/Version] = "public.Actual", [d/Date] = "202401") + 1)

The calculation works for certain "Recs," but there are others that do not change, and I don’t know why. Can someone help?

[Yogeshwar_M]

Hi @Bernardo_Santos1,

Check calculation may remains unchanged due to data locking. Due to data locking value may not be changed so check this cells is it lock or not?

or you can try to add specific member set as per your table in data action script.