topic Re: null issue (Blank value Merge to actual value) in App Development

null issue (Blank value Merge to actual value)

inam — Fri, 15 Nov 2024 21:35:38 GMT

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.

Re: null issue (Blank value Merge to actual value)

Mark_Little — Wed, 12 Jul 2023 06:52:34 GMT

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.

Re: null issue (Blank value Merge to actual value)

inam — Thu, 13 Jul 2023 05:13:54 GMT

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