How to add value to calculate filed?

Question & Answer
,
1

Hi All,

How to add value to calculate filed formula ?
i would like to add calculate filed to count data by lead status as photo below.

image

Many Thanks

2

What are you trying to do?

Can’t you just do count({Policy})

3

Hi max
I want to calculate %
Such as
Close won / submit app = xx%

Thanks

4 
count(ifelse({lead_status}='Close Won',{policy},NULL))/count(ifelse({lead_status}='Submitted App',{policy},NULL))```
6

How to count value by each lead status , do I ha e to create calculate filed by each status ?

Lead status

Close won
Submit
Waiting for payment

Many thanks

7

What are you looking for?

You can do something like this.

count({policy},[{lead_status}])

Or like this

countOver({policy},[{lead_status}])
1 Like