Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV,
I have below expr in my chart.
sum({<Segment={'Group'}, Status = {'Cancelled'}>}[REV YTD])/1000000
Now my requirement is to exclude Cancelled Accounts, means Status is not equals to 'Cancelled'.
How to write the expr for the same.
Thanks,
Ananth
Try with
sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000
means all minus cancelled
sum({<Segment={'Group'}, Status -= {'Cancelled'}>}[REV YTD])/1000000
A minus before the = should exclude it
Try with
sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000
means all minus cancelled
Sorry, both are not working...
Hi,
this must work
sum({<Segment={'Group'}, Status -= {'Cancelled'}>}[REV YTD])/1000000
If not post sample data.
Regards
ASHFAQ
I'm getting error, if I write above expr
I'm sure the syntax is correct, explain with more details, why you say it doesn't work?
It gives error but gives you proper result
To avoid that you have been provided second expression
Which does the same
sum({<Segment={'Group'}, Status = {'*'}-{'Cancelled'}>}[REV YTD])/1000000
Regards
ASHFAQ
The editor dont understand the syntax but it should work...
Hi,
Even if there is red line but it will give you correct output.
Check it.
Regards