6 Replies Latest reply on Jan 14, 2020 1:40 PM by Mohammad Esmaeili

# simple Math, 1 minus (%)

Hi all,

I have a calculated field showing [YTD attr %] of 20%, I created a formula 1- [ytd attr %] , ideally this would give me 80% but its not. I checked looks like the 1 is summon up all the records instead. is there a solution to solve this?

Thanks.

kw

• ###### 2. Re: simple Math, 1 minus (%)

I must be missing something?

• ###### 3. Re: simple Math, 1 minus (%)

Hi Kevin

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 %]

Jim

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.

• ###### 4. Re: simple Math, 1 minus (%)

Did you try

1-Sum(whatever)

• ###### 5. Re: simple Math, 1 minus (%)

Thanks to both, they both work.

• ###### 6. Re: simple Math, 1 minus (%)

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.