if statement using expressions

[#1]

Hi all,

My problem is that I can't make my  IF statement to work.

Model of my problem:

My data:

House type	Price1	Price2
A	1000
A	3000
B		7000
B		8000

Want to get pivot table:

House type	Price
A	4000
B	15000

Price is expression:  if([House type]=('A'), $(eSumPrice1), $(eSumPrice2))

My expressions:

eSumPrice1=Sum(Price1)

eSumPrice2=Sum(Price2)

It must be so simple, pls help me ASAP!

Tiv0li

[jeffmartins]

Hi tiv0li321,

I tried to use your expression and it works for me. Maybe you didn't create the variables eSumPrice1 and eSumPrice2.

See the attached file.

Regards

[Gysbert_Wassenaar]

In your case you don't need if statements. Just use sum(numsum(Price1,Price2)) instead.

[MayilVahanan · Accepted solution]

Hi

Try like this

=RangeSum(Sum(Price1),Sum(Price2))