Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set analysis for a text object to calculate sum of all employees starting with 4.
sum({<empid={"4*"}>}sal)
But when a particular emp id like 4000 is selected, that is not showing for 4000 and still showing for all employees with 4.
How to achieve this.
You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:
sum({<empid*={"4*"}>}sal)
You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:
sum({<empid*={"4*"}>}sal)
I agree with @GaryGiles here, But you can still try multiplying with dummy row alike.
sum({<empid={"4*"}>}sal)*Sum({$} 1)
Works perfectly. Thank you!!