Nothing wrong in your calculations only thing which I've observed is you should use the original values of MeasureType field. You've assigned aliases to MeasureType field and using alias value in your calculated fields that's why you're not getting any output. See the screenshot. Values outlines with blue are the original values of MeasureType field and values outlined with red are the aliases
So you need to use original values in your calculated fields like that
IF [MeasureType]="Shipment Value (in U.S. $)" THEN [Total] END
IF [MeasureType]="Shipment Weight (in kilograms)" THEN [Total] END
Hope this help.
2018 Trade Data.twbx 862.2 KB
Thank you so much!
Glad it helped If possible kindly close the thread by marking my answer as correct so that it gets hide from unanswered list and help others who have similar question.
Oops thanks for the reminder.