Yep found it. I'm getting this syntax error -
What am I doing incorrectly?
Look at my previous post. You're missing the "Iif" in the expression. Basically this expression is an if condition
Hey Sai_Maganti
Again, thank you for you help.
I have the expression correct - however how do I isolate it to 'Average Fleet'
The field type is set to decimal, and have second axis on.
I don't understand what you meant by isolate 'Average Fleet" ??
Apologies if I wasn't clear.
When I use this calculated field (expression) and add it to the value pane. It doesn't bring in any values from Average Fleet Total.
I'm looking to grab the avg fleet values and plot in on the x and y axis as a column chart.
You need to check your data for Account "Average_Fleet_Total" and why it is not returning any data. Add a grid view component within this chart and drag this calculated measure and see what's the data like
