Make one activity count as 1,5

3 posts / 0 new
Last post
gabriew
Make one activity count as 1,5

Hi 

How do i make one activity type in BA count as 1,5  instead of 1?

gabriew
This is in the activity vs

This is in the activity vs budget, that i want some of the activities to count as 1,5 instead of 1

 

Frode
Frode's picture
Make one activity count as 1,5

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.

 

Log in or register to post comments