Need help with set analysis syntax explanation

sai_katare — Sat, 16 Nov 2024 20:09:37 GMT

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

Re: Need help with set analysis syntax explanation

Vegar — Sun, 01 Sep 2019 22:23:15 GMT

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

)