Custom Field

[jyothish8807]

Hello All,

I am stuck with a situation and need your help:

I have 4 fields say:

A,B,C,D

Out of this A & B are comming from the sheet.On the other hand C & D are custom field.The trick over here is:

C=A+B+D

D=B+C

How can i acheive this?How to create C & D which are interdepended.Iam trying to impliment this on a straight chart.

Regards

KC

[anbu1984]

These calculations doesn't make sense. Can you explain with your real data

[ThornOfCrowns]

Those sums are a mathmatical impossibility, what are you really trying to do?

[jyothish8807]

Sorry anbu cant share the real data.

Trick over here is:

Field C value is depended on Field D and Field D value is depended on value of C.

So i have to create two dependent Custom field.

Regards

KC

[#5]

In your calculations,  D is dependent on C and C is dependent on D. So, in order to do this calculation at least one value should be independent then you can add these custom fields using sum in calculated fields or expressions depending on the object,

[jyothish8807]

Thats what even iam thinking, but iam having a scenario like this.Really confused how to impliment this.

Can you let me know how to create a custom field in straight chart and use that field in any other field?

I mean how to use the custom field name?

Regards

KC

[anbu1984]

-Create a label for your first expression

-Use that label in your second expression