Hi Rob,In this case, the difference field should be populated as integer default value 0 and should work fine.Thanks,Nainy Jain

Hi Rob,I am not able to reproduce the issue in my system.Please check if all the difference attributes are of type "long" or "double" in your schema.Thanks,Nainy Jain

Hi robertw937098 ,Please follow the syntax as below:I have calculated the average of 2 values, you can use below formula for 3 values:([target/@diff1]+[target/@diff2]+[target/@diff3])/3Also, you can see the average field(converted to Integer) in display target:Thanks,Nainy Jain

Hi robertw937098 ,The instance variable value is getting overridden in your script. It will always contain the average difference of the last customer.To calculate the average for each row, you can use the Enrichement activity using below steps.1. In "Add additional data", add a new output column fo...

Hi Sri Bhargav,Please use an Enrichment activity before data extraction activity to add a new "Primary Key" column in the temporary schema.Here, I have stored the primary key of the transient table in an event variable "vars.key". In the Enrichment activity, go to "Edit Additional Data" and add a ne...

HiI am Nainy Jain from GMO team in Adobe. I have joined Adobe recently and my role is Associate Technical Consultant. I have 2 years of experience in Adobe Campaign Management and I look forward to learning and contributing to the community.ThanksNainy Jain