09-14-2023 10:52 AM - last edited on 09-15-2023 04:50 AM by JackLacava
Hi All,
I want to seed the data from below source, please help me how to write a code for the below data copy.
Target:-
api.Data.Calculate("V#PERIODIC:O#Import:U3#" & UD3 & ":U8#UND_UD8:U4#" & CurrWk & "=
Source:-
RemoveZeros(S#Actual:U4#TOP:T#" & Priortime & " - S#Weekly_Processes:U4#Week_1:T#" & Priortime & " - S#Weekly_Processes:U4#Week_2:T#" & Priortime & " - S#Weekly_Processes:U4#Week_3:T#" & Priortime & " - S#Weekly_Processes:U4#Week_4:T#" & Priortime & ")","A#KPI_PPV_MONTHLY,A#KPI_TOT_PURCH_DPO",,,,,,,,,,,"U8#Top",,,True)
09-14-2023 04:08 PM
When trying to set account type dimensions (e.g. the UD's) on the left hand side of the equation dynamically, you are going to need to look into using unbalanced math functions or creating a data buffer and setting calculated cells into the buffer.
I highly recommend the 'OneStream Finance Rules and Calculations Handbook'.