V
vignesh kumar
Guest
Thank you its very helpful. In the same query if i need to calculate for different types,suppose a table has different policy types i need to find the sum of amounts of that type and also the no. of records in that type, something like this, for each uwm100 where trndat >= 12/29/14 and trndat <= 12/28/15 and releas = yes no-lock break by poltyp: if first-of(poltyp) then do: assign a = 0 i = 0 . end. if poltyp = "FIA" then assign a = a + uwm100.prem_t i = i + 1. else if poltyp = "FFF" then assign a = a + uwm100.prem_t i = i + 1. else if poltyp = "ECA" then assign a = a + uwm100.prem_t i = i + 1. else if poltyp = "EMB" then assign a = a + uwm100.prem_t i = i + 1. else if poltyp = "CSV" then assign a = a + uwm100.prem_t i = i + 1. I need to do the same for two tables and export the variable a & i. can you please help on this.
Continue reading...
Continue reading...