Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraj6
Contributor II
Contributor II

How to include Null values

Hello Guys,

I need a help!

Nagaraj6_1-1689153147396.png

for  ex:01-04-2023 ,DOM Holiday FIT I want to include  Null count 56 to Direct ,Email+Ma,Orgnic,Refferal, 

I have formula & expected output: Direct count is 18 then   18+(18*56/454)=(18+2.2)=20.2=21,

                               Email+Ma count  is 8  then 8+(8*56/454)=(8+0.9)=8.9=9

How to apply this formula in script.for entire month I want  to apply.

 

 

 

Labels (2)
1 Reply