Hi
How do i make one activity type in BA count as 1,5 instead of 1?
This is in the activity vs budget, that i want some of the activities to count as 1,5 instead of 1
Hi!
It is possible.
I suppose you are using the datatable dAppointment.
One suggestion is that you crete a new calculated column in this datatable and add the following SQL syntax:
case when TaskId = 1 then 1.5 else 1.0 end
TaskID is the unique ID for the appointment activity type. You need to change the number 1 to your number in your CRM-system.
When using it in the dashboard you use SUM as aggregator.
This is in the activity vs budget, that i want some of the activities to count as 1,5 instead of 1
Hi!
It is possible.
I suppose you are using the datatable dAppointment.
One suggestion is that you crete a new calculated column in this datatable and add the following SQL syntax:
TaskID is the unique ID for the appointment activity type. You need to change the number 1 to your number in your CRM-system.
When using it in the dashboard you use SUM as aggregator.