Skip to Content
0
Former Member
Feb 24, 2009 at 01:46 PM

Calculations in output of a BI query

35 Views

Hi,

We use a BI query in our model which gives us an overview of activity status within a campaign. So, we give a campaign_id as variable and we receive a list of status with the number of activities that have that status.

For example:

We give campaign_id=TEST as variable and receive this list:

Status  No. of activities
Open    4
Closed  32

Question 1: How can I make some sort of calculation of the total number of activities(so like sum up the cloumn No. of activities in the output table?

Question 2: How can make the following calculation

(No_of_activities_with_status_open / No_of_activities_total) * 100%

?

So actually I want to calculate the percentage of a certain status and display that in a table. Any suggestions?

thanks in advance and best regards,

Jan Laros