null issue (Blank value Merge to actual value)

[inam]

Hello Community

in my data I found blank value So I want all my blank value merge into actual data.

current output:-

here I found 58 blank data in Dom holiday FIT so i want to apply below formula for each field(direct, email + ma, organic, paid & referral)

for example:-   

(16*58)/506

16 = Direct total as per the report

58 = No source data (blank data)

506 = total of direct, email + ma, organic, paid & referral

how I apply this formula in my script? I have given only 1 date ..I have  to calculate for 1 month.

[Mark_Little]

There are a couple of ways, but you are going to need to do a resident load and a group by something like

LOAD

DATE,

(IF(PROD_TYPE= 'Direct', SUM(VALUE)) * IF(ISNULL(PROD_TYPE))) / SUM(PROD_TYPE) AS New_Value

RESIDENT Table

Group By Date;

Value being the column your summing in your table, If you are count the field just replace the sum with a count.

[inam]

i have used this formula & its working fine.

formula :-  =count(PROD_TYPE)+count(PROD_TYPE) * count({< PROD_TYPE = {''}>}
                     total <[Product Type]> PROD_TYPE) /count(total <[Product Type]> PROD_TYPE)

but I got null value .can you please help how I remove this  65 & 37 below values

so if I remove 65 i want total should be 499.  same as if 37 remove total should be 205

I have used backend script below