Set analysis on satisfying 2 conditions

[siddharth_s3]

The below dimension works, however, I want to edit the dimension for 2 conditions.

1) Show Voucher_ID when the value 1 is not equal to 0 (this works)

OR

2) Show Voucher_ID when value 2 is greater than 0 (not sure how to incorporate)

AGGR(ONLY({<Voucher_ID={"=ROUND($(=$(vExpr_REPO_TxableExpenseRevenue))-$(vExpr_GL_Total_Expense_Revenue|Total_Error))<>0"}>} Voucher_ID),Voucher_ID)

 Basically, the above condition should also satisfy, when 

$(vExpr_GL_Total_Expense_Revenue|Total_Error))>0

satisfies too.

[siddharth_s3]

Bump. Anyone.

@sunny_talwar . Could you please help?

[sunny_talwar · Accepted solution]

May be this

Aggr(Only({<Voucher_ID = {"=Round($(=$(vExpr_REPO_TxableExpenseRevenue))-$(vExpr_GL_Total_Expense_Revenue|Total_Error)) <> 0 or $(vExpr_GL_Total_Expense_Revenue|Total_Error)) > 0"}>} Voucher_ID), Voucher_ID)

[siddharth_s3]

Sorry for the late reply. I saw your reply in another post and that had answered it. 🙂