Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Thanks Juraj it worked