1 Reply Latest reply: Apr 27, 2017 9:14 PM by John Cavoulas

# Move calculations from expressions to the load script

I need some help to move 13 calculations from a pivot expressions to the load script and to create the 14th calculation that will add the results of previous 12. The formulas works with previous loaded fields and will then be used to create visualizations. I'm attaching some dummy data as reference. Any suggestions will be greatly appreciated.

• ###### Re: Move calculations from expressions to the load script

Hard to say but it looks like you might just take each expression, such as AA below,

=IF(

IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA',''))))

and place it into the script in a preceding load statement to your table and give it a field name, one for each expression, a la;

IF(

IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA','')))) as AA

Then, in a preceding preceding load add the new fields together, a la;

AA + Ab + AC... as Combined

I would start this way.