Gradient - Datto BCDR: Agents Count for per agent billed customers
submitted
R
Ricky Cobb
Useful for Gradient billing integrationFor 3 customers returns number of agents if customer is billed by agentCustomer Name 1Customer Name 2Customer Name 3For everyone else not billed by agent, returns 0
multiply(to_number((SystemInfo.clientCompanyName ==
Customer Name 1
|| SystemInfo.clientCompanyName == Customer Name 2
|| SystemInfo.clientCompanyName == Customer Name 3
) | replace(to_string(@), to_string(true
), to_string(1
)) | replace(to_string(@), to_string(false
), to_string(0
))),to_number(SystemInfo.agentCount | replace(to_string(@), to_string(null
), to_string(0
))))