Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
COUNT(if(CATEGORY = 'LIABILITY' AND DATESTART>=DATEPREVFINYEARSTART, CUSTOMERACCOUNTID))
I want to convert this expression into set analysis exp.
like count({$<CATEGORY = {'LIABILITY'}>}CUSTOMERACCOUNTID)
I don't know how to complete the expression.
Please help me out.
Thanks.
Thank you.
Small thing still remaining
IF(MODULE = 'OD', AMTSANCTIONEDLCY, IF(MODULE = 'LOANS', AMTCRTURNOVERTODAYLCY))
In Set Analysis Format...
Is this an expression or dimension?
Expression
SUM(IF (AMTDEBITBALLCY > 0 AND (AMTTOTALODUTILIZEDLCY > AMTTOTALODLIMITLCY) and (APPLICATIONDATE = DATEFIRSTOVERDRAWN )
, AMTDEBITBALLCY - AMTTOTALODLIMITLCY))
I want to following data
| FOLIO_NUMBER_UHR | TOTAL_NO_OF_UNIT_OF_UH |
| 1 | 166633.7933 |
| 2 | 0.3334 |
| 3 | 0.12 |
| 4 | 133333.3333 |
| 5 | 2500 |
After applying following condition Folio number 2 and 3 disappear.
ApplyMap('UH_REGISTER_MAPPING', FUND_ID &'-'& FOLIO_NUMBER, 0) >> 0