Hi, everyone
I not sure i faced this problem is whether there have missing value that cause me cannot caluclate the column or not?
Now, I want calculate the rate by using the formula below in the script, but some data table consists of missing value
Because before that the data table that doesn't have missing value, I able to calculate the rate.
So, May I know how to fix the above problem that I faced.
Any answer is appreciate.
Thanks.
Below is my script that already joining the 2 data table together.
dt_Join = dt_firstseq_summary << Join(
With(dt_final_summary),
Select( :S_B_Name_WS1, :N Rows, :Name( "Percent" ) ),
SelectWith( :S_B_Name_WS1, :N Rows, :Name( "Percent" ) ),
By Matching Columns( :S_B_Name_WS1 = :S_B_Name_WS1 ),
Drop multiples( 0, 0 ),
Include Nonmatches( 1, 1 ),
Preserve main table order( 1 ),
Output Table Name("Combined Table");
);