Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
You mean when you select multiple timestamps? Do you want to ignore selections in timestamp field?
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.