Average multiple dimension in a new calculated field.

[yadavsaket1]

Hi,

Just need to average multiple dimension into one calculated field. also if there is a null value the average should not consider that in the calculation.

Thanks in advance.

[JordyWegman]

Hi Yadavsaket,

What do you want to with this? Don't you mean a measure?

You can just use this formula, null() values are not calculated.

Avg([Your field])

 Jordy

Climber

[yadavsaket1]

Hi,

Actually, there is more than 1 measure.

I have attached an excel file that makes it easy to understand.

check that it is not considering null values. I need to do this in Table(Data Manager).

Thanks in Advance.

[JordyWegman]

HI Yadavsaket,

This is something you can't do in the Data Manager. We can do it in the script if you want, okay?

Jordy

Climber

[yadavsaket1]

Sure. That will do.

[JordyWegman]

Can you send the information in your load script?

Jordy

Climber