Hi,
Please refer the sample data set below, I want to calculate the total sales of each hotel, using if Condition.
I used the following expression : Sum({<PropertyName = {'Hotel001'}>}Revenue), but this return the output as "0".
Guidance on this matter is highly appreciated.
| ACCOUNTID | PropertyName | Revenue |
| 11 | Hotel 001 | $ 15,000.00 |
| 12 | Hotel 001 | $ 7,500.00 |
| 13 | Hotel 001 | $ 2,000.00 |
| 14 | Hotel 001 | $ 4,000.00 |
| 15 | Hotel 002 | $ 4,200.00 |
| 16 | Hotel 003 | $ 3,500.00 |
| 17 | Hotel 004 | $ 2,150.00 |
| 18 | Hotel 002 | $ 2,360.00 |
| 19 | Hotel 003 | $ 5,410.00 |
| 20 | Hotel 004 | $ 6,500.00 |
| 21 | Hotel 004 | $ 2,500.00 |
