Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

[jblomqvist]

Hi all

Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

For example I have a SalesAmount field.

For some charts, for some users I want to show the result of Sum(SalesAmount) where it exceeds 100,000 in value otherwise display 0.

So out of 10 users who have access to the application, for some users I want them to see all the values, but for others I want them to only see results where Sum(SalesAmount) exceeds 100,000.

Is this possible?

[Bill_Britt]

Hi John,

Never tried to use an if statement in section access. However, you can have two charts on top of each other and enable the one for a certain users with a calculation Condition.

Bill

[stigchel]

As far as I know not, but you can create an access field e.g. FILTER for those users and use something like

if(FILTER='Y',

Alt(Sum({<Product={"=Sum(Sales)>=100000"}>}Sales),0),

Sum(Sales)

)

Example attached