iB::Topic::SIAG dates

	Damn Small Linux :: Damn Small Linux Board The DSL Forums

» Welcome Guest
[ Log In :: Register ]

Damn Small Linux Board » Damn Small Linux » Other Help Topics » SIAG dates

		Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
		Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic

Pages: (5) </ 1 2 [3] 4 5 >/

[ Track this topic :: Email this topic :: Print this topic ]

Topic: SIAG dates, date format

< Next Oldest | Next Newest >

JohnJS

Group: Members
Posts: 200
Joined: Oct. 2006

Posted: Mar. 24 2007,16:07

You're correct. After importing csv file to OO I then add formulae.

Here's a couple of straightforward IF stmnts.

#if(e5>10,e5+g4,"none")#

#if(e5,g4-e5,g4+f5)#

Note: I don't place = or + before the IF. Seems to work okay.

e5 g5 f4 formatted to 'fixed'.

Used above for my checkbook register.

oops: should be e5 g4 f5

Have you checked out /knoppix/usr/local/share/siag/siag ?
Especially 'functions.scm'

jpeters

Group: Members
Posts: 804
Joined: April 2006

Posted: Mar. 24 2007,19:56

That's what I tried, and it doesn't work; instead it selects the first choice no matter what. I tried your example; same error.

Thus:

if(5>10, 9,0) produces 9. I'm surprised it works on your copy, since I'm using ver 3.5.7

JohnJS

Group: Members
Posts: 200
Joined: Oct. 2006

Posted: Mar. 26 2007,15:35

Hi jpeters,

The second example I gave was for my cb register it has been working.

if(debit,bal-debit,bal+credit)

The > or < does not seem to work with the IF stmnt. Must be another way to do it. Have been searching the Web but no success so far.

Will let you know if I find the solution.

Edit:
So far I determined SIAG IF statement with < or > works as " if ...then" only.

Have been used to: "if..then..otherwise"

edit:
My mistake, > or < still not working with IF. Darn it.

edit: 3/26 130pm

You're right. So far SIAG is doing the basics for me.
That's all I need most of the time.
Thanks for all the info.

jpeters

Group: Members
Posts: 804
Joined: April 2006

Posted: Mar. 26 2007,19:46

Quote (JohnJS @ Mar. 26 2007,10:35)

My mistake, > or < still not working with IF. Darn it.

Actually, it isn't working with anything. "if(23==45,1,0)" produces "1"

No sense beating a dead horse; Schemes don't work either, meaning a lot of the functions have been stripped out; great if you need a basic chart, but for all else, oo.