You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IfThen formula function Management report

Accepted answer
31
Views
2
Comments

Summary:

Hi All,

For a specific report I have been using the formula function "IfThen", but I am struggling to have the falseparameter defined properly. The goal is to generate a "#missing" , "No Date" or something similar as long as it is no numeric value as there will be an additional average put over the retrieved values. With the current setup all generated 0 values are taken into account in the average calculation, influencing the result heavily while they should be excluded from the calc.

Current situation: IFTHEN(COLUMN[F]=COLUMN[K], AVERAGE(COLUMN[G],COLUMN[H],COLUMN[I]),0)

Should be situation: IFTHEN(COLUMN[F]=COLUMN[K], AVERAGE(COLUMN[G],COLUMN[H],COLUMN[I]),

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!