Formula Inside Set Analysis

[Riccardo]

Hi,

I want to use this expression:

=Only({<ATYPE={'VALUETYPE'},NUM_FROM={"<=1"},NUM_TO={">=1"}>} NUM_RESULT)

This is working fine, NUM_RESULT is the right value that I'm expecting from a between check (1 is between NUM_FROM and NUM_TO).

Now, I want to replace this 1 with a formula like this:

=avg({<BTYPE={'ANOTHERTYPE'},YEAR=P(Year)>} VALUE_PERC)

(I'm using this fomula in a pivot column, I can use also the column alias as field)

it works as a new pivot column, but If I replace the 1 with this, it doesn't work. I tried also with variables but it doesn't work.

I tried:

=Only({<ATYPE={'VALUETYPE'},NUM_FROM={"<=$(vartest)"},NUM_TO={">=$(vartest)"}>} NUM_RESULT)

where vartest is

avg({<BTYPE={'ANOTHERTYPE'},YEAR=P(Year)>} VALUE_PERC)

Thank you, best regards.

Riccardo

[Riccardo]

Hi! Thank you, it is correct and It works fine Thank you very much.

I have a second issue, similar logic but it uses the calculated new column for another range match. I uploaded the NEW app.... Can you check it for me please? Thank you very much

[sunny_talwar]

None of the Totals fall between the ranges for A or B. Am I reading this correct?

[Riccardo]

Yep, you are right. I uploaded the wrong file......... just change range_value where type is A and B

[Riccardo]

I tried changing the value for print A or B but it still doesn't work. It seems that I can't reuse column "TOTAL"