Expand my Community achievements bar.

SOLVED

Can we create calculated field in ACC using any three attribute with same data type (ex. floating numbers) while creating the schema?

Avatar

Level 1

Can we create calculated field in ACC using any three attribute with same data type (ex. floating numbers) while creating the schema?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Ashme ,

Yes, You can create.

For example, If you have 3 attributes (@float1, @float2 and @float3) with data type as 'double' (floating), and if you want to create a calculated field by adding these 3 attributes, you can create a new attribute in the schema as below

    <attribute label="float1" name="float1" type="double"/>
    <attribute label="float2" name="float2" type="double"/>
    <attribute label="float3" name="float3" type="double"/>

<attribute expr="@float1+@float2+@float3" label="Calculated Field" name="exprDouble" type="double"/>

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi @Ashme ,

Yes, You can create.

For example, If you have 3 attributes (@float1, @float2 and @float3) with data type as 'double' (floating), and if you want to create a calculated field by adding these 3 attributes, you can create a new attribute in the schema as below

    <attribute label="float1" name="float1" type="double"/>
    <attribute label="float2" name="float2" type="double"/>
    <attribute label="float3" name="float3" type="double"/>

<attribute expr="@float1+@float2+@float3" label="Calculated Field" name="exprDouble" type="double"/>

 

Avatar

Level 1

Hi @ParthaSarathy ,

 

Thank you for your response. Let me check if it is working fine.

 

Also, What "expr" to use if we have to subtract the fourth attribute?

Avatar

Community Advisor

@Ashme ,

<attribute expr="@float1+@float2+@float3-@float4" label="Calculated Field" name="exprDouble" type="double"/>