Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys, I am using this expression for set analysis:
=num#(SUM({<[UNIQUE_FLAG]={1}, [Status Claim] -={Cancelled}>}([Total Approved])*[Rate]),'USD #,##0.00', '.',',')
I use this expression to my map bubble size
Problem occurs that this expressions gets the total approved of all years, and I want only for the year selected... I have this other field called "YEAR", and I want it added to this expression... so, lets suppose:
YEAR | Total Approved |
---|---|
2010 | 10 |
2011 | 20 |
2012 | 30 |
2013 | 40 |
2014 | 50 |
Total | 150 |
So, When I pick one year, for example, 2011, it gets for me a ratio 20:150 and distribute the points in the map. I would like to get only that 20 and distribute in the map, not the ratio...
I am using the open street map extension attached...
Can someone help me out on this matter, pelase?
It seems that my problem is solved when I turn on/off the webview and change the year when the webview is off...
Does anyone know how that work?
use Year={$(=Max(Year))} in your expression
num#(SUM({<[UNIQUE_FLAG]={1},Year={$=(Max(Year))} ,[Status Claim] -={Cancelled}>}([Total Approved])*[Rate]),'USD #,##0.00', '.',',')
hope this helps
nope, it looks like a bug, or something like it... I turn off and then I turn on the web view and then it starts to work fine...