Set analyses in combination with if statement

[francisvandergr]

I have a question.

i have dimension called "Costcode" and 2 important fields called "amount" and  "accountno"

What i want is when a "Costcode" is selected in my object all values of Costcode must be visible. Something like :

sum( {$<Costcode = >} Amount )

But i want only amounts from "accountno"between 3000 and 4000'.

Can anybody help me with this formula ?

[Anonymous]

Should be something like this ...

sum( {<Codecode=, account= {">3000<4000"} >} Amount)

[#3]

Hi Francis, use this: if(accountno >= 3000 and accountno <= 4000, sum({$<Costcode = >} amount ))

[Anonymous]

@matytr21 -- why using an if, if this can be solved within the set analysis?

[#5]

Yes, you have the reason, with set analysis is better

[francisvandergr]

I have made an example with data. Maybe someone has now the right formula. Iw ant in the textbox a result of 230.  I attached the file

[#7]

So you want it to display 230 even if the selections currently made are not between 3000 and 4000?

So you basically want to ignore the selections in name cost code.

[swuehl · Accepted solution]

Hi

I think you need to clear the field [Name Costcode], you selected in, like

=sum( {<Costcode=, [Name Costcode]=, Account= {">3000<4000"} >} Amount)

Hope this helps,

Stefan