Thursday, August 30, 2012

SityDB Translog transaction type Excel formula =IF(AND(F3=0, G3=10, H3=0), "Credit Card", IF(AND(G3=10,F3=7, H3=0),"Failed CC Transaction",IF(AND(G3=1,F3=0, H3=0), "Coin",IF(AND(G3=1, F3=3, H3=0), "Cash Out",IF(AND(F3=0,G3=1, Where: F3 = tlRecordType G3 = tlPaymentType H3 = tlUserType