if you are doing a sum with a constant it will sum over then number or records involved -
sounds sill y but aggregate the constants like Min( 1)- [ytd attr %]
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Did you try
Thanks to both, they both work.
Kevin, This seems like a LOD to me. have you tried fixing the calculation on the LOD in the view?
Also you might want to Try
MIN(1) - [YTS Attr%]
if this does not fix the problem, I would like to see how the view is structured and I might be able to help you with this.