how to create new report from two existing chart expressions in application

[NehaPD]

Hello All,

Please help me with below scenario were i have 2 charts with different expressions.

status A Expression - =MaxString({< [Default Status] = {$(VcnStatusA)}, Date = {">=$(=min(StatusA_From_Date))<= $(=max(StatusA_To_Date))"}>}CN)

Status B Expression =MaxString({< [Default Status] = {$(VcnStatusB)}, Date = {">=$(=min(StatusB_From_Date))<= $(=max(StatusB_To_Date))"}>}CN)

output what i want to display in different report is CN's which fall under difference of date range selected for both the above charts.

Thanks in Advance

[juraj_misina]

Hi,

you can use standard set operations, so you can as well calculate difference between sets:

MaxString({< [Default Status] = {$(VcnStatusA)}, Date = {">=$(=min(StatusA_From_Date))<= $(=max(StatusA_To_Date))"}-{">=$(=min(StatusB_From_Date))<= $(=max(StatusB_To_Date))"}>}CN)

[NehaPD]

Thanks Juraj it worked