3 Replies Latest reply on Oct 10, 2017 10:01 AM by Jim Dehner

# Creating a calculated field

Hi All,

I have to create a calculated field wherein the original value is multiplied by a factor specific to criteria. PFB pivot table from my source file.

if field criteria is 'A' then calculated field = original value * 0.25 and so on for criteria B, C and D. Request your support in writing the formula.

 Region Criteria Original value Calculated field Asia Pacific A 22 =C2*0.25 B 23 =C3*0.5 C 24 =C4*0.75 D 25 =C4*0 Central, North and South  America A 26 =C2*0.25 B 27 =C3*0.5 C 28 =C4*0.75 D 29 =C4*0 Europe, Africa  and the Middle East A 30 =C2*0.25 B 31 =C3*0.5 C 32 =C4*0.75 D 33 =C4*0 Grand Total 330
• ###### 1. Re: Creating a calculated field

{FIXED Region,Criteria, original value:SUM(IF Criteria="A" THEN (Original value*0.25) ELSEIF Criteria="B" THEN (Original value*0.50) ELSEIF Criteria="C" THEN (Original value*0.75) ELSE (Original value*0.0) END)}

Try above and check for brackets. I just wrote it.

Thanks

Deepak

• ###### 2. Re: Creating a calculated field

one example

create calculated field for criteria

Name Field: A

(ORIGINAL VALUE) * .25

CREATE OTHER CALCULATED FIEL

IF region = 'Asia Pacific' then

A (hera your calculate field, this case is A)

and so you must create field by criteria

• ###### 3. Re: Creating a calculated field

Hi

this is wherre a Case formul make sense

Case [Criteria]

When "A" then [Original Value] * .25

When "B" then [Original Value] * .5

When "C" then [Original Value] * .75

When "D" then [Original Value] * 0

End

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.