Hi,
Thank you all for your kind answers and sorry about confusions. Truly appreciate your time and patience.
Got this solved by another senior member in our team, it was quite a bit more that I thought would be - as it happens.
I can reproduce at a point in time what was done if may help...
Hi Pete,
hmmmm... it's a bit more complicated.
the formula I described is used in a subreport which passes a variable to the main report showing all transactions considered as adjustments or other fees (many codes). The SYS2 and WA are not included in the formula (or in the many codes in the...
Hi Pete,
well, the data in table1.transaction is really a column showing transaction codes so they are in the format TR01....TR15 and some other codes, so basically when I have these codes I want to pull money amounts from table2.amount column. the formula the way I described it works however I...
Hello,
I have a little problem - not sure if it is trivial however can't seem to make it work.
I have a simple formula:
if {table1.transaction} in
['tra1', 'tra2', 'tra3', 'tra4', 'tra5]
then {table2.amount}
else 0
Now, I have another transaction - call it 'sometra'
so what needs to happen is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.