Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Plase try:
= Count ( { 1 < Region=>} Trans_ids)
Hope this helps!
It's not clear to me what you want. Can you post an example document that explain the problem?
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.
See attached example
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?
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.