Hi, try to always remove all zeros from all calculations in order to ensure performance processes, less space being used in the database and other possible issues such as what you are describing here.
You can find the documentation here...
...and here.
Remove Functions Usage (onestream.com)
Your calculation should look like this:
api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = removezeros(S#" & actScenario & ":V#Periodic)", "A#Balance.Base",,,,,,,"U4#Top_Srce.Base.Remove(Calc)",)
api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = removezeros(S#" & actScenario & ":V#Periodic)", "A#Nat_Net_Ctrl_Income.Base, A#S_Dozens, A#S_NCIpct",,,,,,,"U4#Top_Srce.Base.Remove(Calc)")
If you want to specifically only remove real data, you can use a data buffer and filter out the non-real data intersections by checking the isRealData boolean when looping through the data buffer. However, I generally recommend the removezeros() approach.