Set Analysis Help

[#1]

Hello all,

Need your help in removing the following IF condition, via set analysis.

IF(SUM({<BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)>='500000',

SUM({<  AR_BUCKET_FINAL_NEW = {'NOT DUE'}, BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)/vLacs)

[sunny_talwar]

Is this used in a table with just one dimension? or are there multiple dimensions in the table? If you have just one, you can try this:

Sum({<AR_BUCKET_FINAL_NEW = {'NOT DUE'}, BSIK_BUCKET,AR_BUCKET_FINAL, link_Date, TXN_TYPE = {'BSID'}, DimensionName = {"=Sum({<BSIK_BUCKET,AR_BUCKET_FINAL,link_Date,TXN_TYPE = {'BSID'}>}Amount)>='500000' "}>}Amount)/vLacs)