HOw to create a conditional calculation of an expressionq

[#1]

How can i condition that the expression for forecast needs to be calculated only region level any filtering or anything else it should just say N/A?

i have tried some conditions but it is taking high calculation time like,

if((IsNull(GetCurrentSelections( )) OR (NOT IsNull(GetFieldSelections([Channel Name]))AND SubStringCount(GetCurrentSelections( ),':')<=1)),

i am trying to see is there any different condition which would be a quick solution in-spite of this huge calculation as i need to use this condition in many objects on the same sheet.

[salto]

Plase try:

= Count ( { 1 < Region=>} Trans_ids)

Hope this helps!

[Gysbert_Wassenaar]

It's not clear to me what you want. Can you post an example document that explain the problem?

[#4]

i have attached the app with sample data to the initial posting.

the issue is i dont want forecast to show up if i filter on anything apart region if anything else is selected it should show N/A.

hope this helps.

[Gysbert_Wassenaar]

See attached example

[#6]

Gysbert, this definitely solves the issue but should i be worried about the calculation time? as i need to use the same condition on different objects?

[Gysbert_Wassenaar]

Probably not. The variable value is calculated once and then cached for use by expressions. But the only way to make sure is to test.