Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
=RangeSum(Sum(Price1),Sum(Price2))
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
In your case you don't need if statements. Just use sum(numsum(Price1,Price2)) instead.
Hi
Try like this
=RangeSum(Sum(Price1),Sum(Price2))