If I wanted to add a 3rd column to the below code to calculate the margin target ('Target' multiplied by 'Target %') how would I do that?
customer_profile_target.cpt_target As Target,
customer_profile_target.cpt_target_percent As [Target %]
If I wanted to add a 3rd column to the below code to calculate the margin target ('Target' multiplied by 'Target %') how would I do that?
customer_profile_target.cpt_target As Target,
customer_profile_target.cpt_target_percent As [Target %]
customer_profile_target.cpt_target * customer_profile_target.cpt_target_percent As [Margin Target]