Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Posted: 31 Oct 2017 at 5:43am
PCTSPLIT is a number, so did something like this
totext(PCTSPLIT) + TRANSID and used it in the evaluate
but i think the issue is deeper here
Based on the PCTSPLIT if its a not 100% then i have to sum up the amount which in below case should be 1500 but with concatenation of TRANSID and PCTSPLIT it is still giving me 750.
NOt sure how to tackle all these conditions
Policy PCTSPLIT TRANSID AMT
JKC69 0 RC 0
50 DU 750
50 DU 750
50 DU 0
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 31 Oct 2017 at 5:53am
What I would suggest is to try to understand how you would "manually" add these up and how you would know to include and exclude rows based only on what values are available to you. Sometimes there are other fields (primary keys) in your data set that you would never think to display but are the exact value that you would want for the condition. If you can figure out the "data logic", likely someone can assist in converting that logic into a formula.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
