Jump to content

Spotfire Expression

Mohd faizal Adris

Recommended Posts

Don't put any Boolean expressions in your over statement.


If you only want to evaluate for this certain condition please use p.shu's approach.


Otherwise you could do:


max([c_Goal]) over ([C_Fiscal Year],[sITE],[KPI])) 


and then filter to your condtiton. Or simply use a cross table.


But it all depends on your requirements. Do you just need the value in a dash board Do you need it as a calcuted column .. Please clarify if you need further support.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...