ignore a value

[#1]

hi all

i have a field SHIFT

SHIFT:

A

B

C

D

i want to ignore value D.  how can i do.

Thanks

[jonathandienst · Accepted solution]

Hi

You have not been very specific.

To exclude in script: LOAD A, B, C From Table;

To exclude in calc dimension: If(SHIFT <> 'D', SHIFT)

To exclude in expression: Sum({<SHIFT-={'D'}>} Value)

Hope that helps

Jonathan

[#3]

Hi Jonathan,

If I could get more specific.  In an expression on a pivot chart.

sum({<STEP_SECTION={"PAC"}>}QUANTITY)  .....This works......

sum({<STEP_SECTION.={"PAC"}>}QUANTITY)  .....This doesn't work......  And <> instead of .= doesn't work either.

I'm trying to exclude PAC instead of only include it.

Thanks

BobC.