Formula Indicator

[pgalvezt]

Hello,

I have a formula in my control indicator. But just works fine when I selected one filter. I would like to show the real result without selections in my filter...

So my outputs are:

Both Select gives 23%.

I would like to obtain 23% without Selections and not 123,8% .

Thanks You!

[#2]

Pablo:

Hard to tell what you are really trying to accomplish (my Spanish is marginal at best). It appears to me that your formulas may not yield the results you are seeking. To really simplify, you have:

(-a -b) / (-b), or eliminating the - (negative signs), (a+b) / b

Where a and b are your two sums with set logic. A standard growth calculation would be:

(current-previous) / (previous), or (current/previous) - 1

- or in your case

(a-b) / b

Or in the case of gross margin:

(revenue-cost) / revenue, or (b-a) / b

Whichever the case, I think you want the difference between the two items in your numerator - not the sum of them.

[pgalvezt]

Hi Greg,

Hard to tell what you are really trying to accomplish : I need to show 23%. If you do clic in both filters P and O you will see that the final result is 23%. I need the same result but without selections.

I almost sure that my formula need an aggregation, But I´ve tried but doesn´t work.

[MindaugasBacius]

Maybe Set analysis is the problem solver?

[pgalvezt]

Yes, I almost sure that my formula need an aggregation, But I´ve tried but doesn´t work.

[#6 · Accepted solution]

Pablo:

so you would use the set expression: {<TipoExpression={'Otros'}>} for the numbers that need 'Otros', and {<TipoExpression={'Pagos'}>} for numbers that need 'Pagos', when you build your formulas. As an example

sum({<TipoExpression={'Otros'}>} fieldname) - sum({<TipoExpression={'Pagos'}>} fieldname)

as for 23% - what it appears you'll need is the combination of the two values, or a set expression like {<TipoExpression={'Otros','Pagos'}>} or in the larger example:

sum({<TipoExpression={'Otros','Pagos'}>} fieldname)

Hope this helps...

[pgalvezt]

Works now thanks!