Creating reports and dashboards | Stimulsoft community forum

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.

Hello,

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

Thank you.

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

Hello,

Please send us your report with test data for analysis.

Thank you.