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