Find Jobs
Hire Freelancers

Need Help with a Custom Formula for a SalesForce Report

$30-100 USD

Dibatalkan
Disiarkan sekitar 12 tahun yang lalu

$30-100 USD

Dibayar semasa penghantaran
I am trying to finalize a SalesForce report but I am having trouble creating a couple of custom formulas for the report. I need: 1) a formula to calculate how long an item has been in an "open" call status based on created date to current date. I believe this formula should be something similar to the below but I haven't been able to get it to work: IF(ISPICKVAL(Status , "Open"), ROUND(NOW()-CreatedDate, 0), null) 2) I need a formula to calculate first call resolution based on calls that were marked as "completed" on the first call compared to all calls taken. I have attached the current report sample showing the different fields. I always leave excellent 10 feedback for a job done well. Please send me your best bids.
ID Projek: 2724533

Tentang projek

2 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
2 pekerja bebas membida secara purata $16 USD untuk pekerjaan ini
Avatar Pengguna
See private message.
$25.50 USD dalam 2 hari
4.8 (26 ulasan)
5.0
5.0
Avatar Pengguna
See private message.
$7 USD dalam 2 hari
5.0 (14 ulasan)
2.7
2.7

Tentang klien

Bendera UNITED STATES
Charlotte, United States
5.0
217
Kaedah pembayaran disahkan
Ahli sejak Mac 12, 2005

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.