Count of ID with sum condition

[deepakkrish]

Hi All,

This is my expression , I want to calculate the ID based on the below condition.I wrote some expression but the value changing when i select multiple stamp.

Condition: Calculate ID ,

if sum of price is less than or equal to 500 and status not equal to lost and stage equal to propse , booked and group not equal to owner and care.

Dimension : TimeStamp

expression: =(1-(Count({<ID={"=Sum(Price) <= 500"}, Status -= {'Lost'}, Stage = {'Propose', 'Booked'},
[Group]-={'owner','care'}>}DISTINCT  ID)
/
Count({<Stage-={'Cancelled ','Sales'}>}DISTINCT  ID)))

Regards,

Deep.

[deepakkrish]

@sunny_talwar 

[sunny_talwar]

You mean when you select multiple timestamps? Do you want to ignore selections in timestamp field?

[deepakkrish · Accepted solution]

Thanks for the quick reply @sunny_talwar . 

I wrote sum of condition in script and apply it on expression . It's working now .

Thanks,

Deep.