I did - but how do I select avg fleet acct? I'm using a CV MD data adapter fyi.
Right you should create a calculated field with formula something like this..
Iif(StartsWith([Account]), 'Asset Yield Pct'), [Amount], 0) --Add all your account conditions for you Avg Fleet Acct
Make this Field Type Decimal and add this to your values pane and then choose Average as shown in the pic below
Thank you for your patience, Sai_Maganti. I'm new to Dashboards building.
Where do I add this expression? - Iif(StartsWith([Account]), 'Asset Yield Pct'), [Amount], 0)
if you can show this setup within your expression/filter editor - that would help a lot.
Here we go. Once created add your expression and then rename it to what ever you want and then set the field type to decimal.
Yep found it. I'm getting this syntax error -
What am I doing incorrectly?
