OVER Formulas wrapped in CASE statements

[David Ruscoe 2]

Hi all,

I have been googling this for too long and am hoping someone as the answer. I have a property control when the users need to choose a Month "Current Month". When doing it tis way I need to wrap my OVER formulas in a case statement. If I try this..I get the infamous 'Invalid configuration' message.

case when DocumentProperty("CurrentMonth")=String([Month]) then Sum([FTE]) / Sum([FTE]) OVER (AllPrevious([Job Title])) end

It requires me to put my 'Sum' up front but have no idea how to do that on the OVER part.

This is a Graphical Table I am using..so it acts like a Cross table with the formulas

Any ideas

Thanks,

David

[Shashank Gurnalkar]

Hello David,

 

I can take a look into this if you can attach your Spotfire analysis file with embedded data. You can embed the data by going into Data Table Properties >> Select the table in use >> check the radio button 'Embedded in analysis' >> Click OK.