Computed column

SMART Community Forum
1

Hello everyone:

I need help with this . I am generating this column that is the result of multiplying the frequency of observation of threats by distance patrolled to obtain the CPUE.
the formula is

image
image707×232 6.83 KB

when I run the report by year the result is correct
image
image865×324 47.8 KB

, but when i run for 2 years range de result of column CPUE is the sum of both year
image
image1370×92 4.82 KB

This is the aggregation
image

I think es very simple the solution, but i can´t find it.

Thanks

2

Hi Jorge,

As it’s generating the number it looks like the expression may be the issue. In this case I see that you’re using the existing CPUE generated through the query itself in the formula, which may be the problem.

You can try the formula as below. Although, the “compute rate” function in the query should remove the need to do this as a computed column in your report.

Hope this helps.

Cheers,

Alex

image

image
image1920×1032 38.9 KB

1 Like
3

Hi Jval

You need to remove the SUM on aggregation

image

Regards

Lili Sadikin

2 Likes
4

Thanks for the help.

5

Alex:

Thanks for your help. I noted that when a i did a review of data queries.