How to add value to calculate filed?

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.


Many Thanks

What are you trying to do?

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

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


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

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

Lead status

Close won
Waiting for payment

Many thanks

What are you looking for?

You can do something like this.


Or like this

1 Like