Joined: 15 Nov 2011
Online Status: Offline
Posts: 29
Topic: problem with formula Posted: 20 Dec 2011 at 10:22pm
Hello
I have a list of transaction report and I need to restrict transactions types for non-control accounts.
If an account is a control account then show all transactions types but if it is not a control account then show all transactions types except 13,14,18,19). I was thinkng about using select case but somthing is wrong in it, please help!
SELECT CASE {Command.Controlaccount} CASE "Y" FORMULA = {Command.TransType} CASE "N" FORMULA = ({Command.TransType} <> "13, 14, 18, 19")
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