Using If Condition to Calculate Sum of Sales

[KKumar92]

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

[petter · Accepted solution]

Sum({<PropertyName = {'Hotel 001'}>}Revenue)

This should work, seems like you missed a space there...

[KKumar92]

Thanks for the instructions, I got the expected Output.