Clustered Column - Graphic

[brjohnsmith]

Hi, I need to create a clustered column with 2 series; for the first series, Series 1, I have the info, and it works fine; however, for the 2nd series, Series 2, it is necessary to do a condition based on the calculation. See the example: {iif((field1-field2)>100,100,iff((field1-field2)<=0,0,field1-field2)}—how can I do it in the graphic, and where can I use the condition? Thx.

[Lech Kulikowski]

Hello,

You can add the calculated column in the data source and then use it in the Chart component.

Thank you.

[brjohnsmith]

Hi, field1 and field2 are in the data source column, but the calculation does not belong to the data source column, it is an independent text field where there is only the calculation, however, if you know how this field text calculation is added to the column, please let me know. I thought in using in the list of value or value in the series graphic, but I am not sure if it is correct, because, if it is, the syntax is wrong. Thx

[Lech Kulikowski]

Hello,

Please send us your report with test data for analysis.

Thank you.