Need help with set analysis syntax explanation

[sai_katare]

Hi everyone,

I have a sample set analysis expression (below) and i need to understand what does it means/does. 

Sum(TOTAL<Dimension1,Dimension2,Dimension3,Dimension4,Dimension2>{$<type=,flag='Y'},fail_type=,Event=,SubEvent=, Code=,SubSystem=>}Quantity

Thanks,
Sai

[Vegar · Accepted solution]

You  have a syntax error in your set, a missplased } sign and lack of an ending ) sign. You should change it to this: 

Sum(TOTAL<Dimension1,Dimension2,Dimension3,Dimension4,Dimension2>{$<type=,flag='Y', fail_type=, Event=, SubEvent=, Code=, SubSystem=>}Quantity)

Explanations

Sum( TOTAL  //total sum  ignoring your table dimensions except...

<Dimension1,Dimension2,Dimension3,Dimension4,Dimension2>  // these dimensions are excepted from the TOTALing.

{$< //using your current selections with some modifications...

type=, flag='Y', fail_type=, Event=, SubEvent=, Code=, SubSystem= //... ignore any selection made to any of these fields

>}Quantity // you are calculating the values in the field named Quantity

)