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

[Ashme]

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

[ParthaSarathy · Accepted solution]

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"/>

[Ashme]

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?

[ParthaSarathy]

@Ashme ,

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