Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a number range 1-1000 which I successfully import.
No 15,25,50,75 and 90, I need to exclude from all calculations but later on a seperate sheet display my analysis.
How do I go about doing this.
My statement reads as follows -
If([number] >=1 and [number] <= 10000, 'Valid','Not defined') as d_type
create a flag for these numbers as a new field and use it in set analysis
if([number]=15 or [number]=25 or [number]=50 or [number]=75 or [number]=90, 1, 0) as CalculateFlag
If( ([number] >=1 and [number] <= 10000) And Not([number]=15 or [number]=25 or [number]=50 or [number]=75 or [number]=90), 'Valid','Not defined') as d_type
If(
([number]>=1 and [number]<=10000)
and not Match([number],15,25,50,75,90),
'Valid','Not defined'
) as d_type
Hi
I am assuming from your post that you want to load these numbers, but exclude them from your calculation(s). Thne use the following set expression to exclude them:
<number -= {15,25,50,75,90}>
Use it in an expression like this for example:
Sum({<number -= {15,25,50,75,90}>} amount)
The -= will flag as a syntax error in the expression editor. This is a bug in the syntax check, so just ignore this warning.
HTH
Jonathan