HomeForum
Welcome, Guest

New menu item "Correct calculations"
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: New menu item "Correct calculations"

New menu item "Correct calculations" 1 year, 3 months ago #1595

Hi Peter,

I'm sorry but I can't determine what you mean by the target fields grid. Please advise.

Thanks

---------------------------------------
Right click on target fields grid
Please use our support for so we can all benefit

Peter


-------Original Message-------
From: Vaughn, Steve
To: DB Software Laboratory
Subject: New menu item"Correct calculations"
Sent: 17 Feb '11 21:13
Where can I find the new menu item"Correct calculations" as stated below?

Thanks
Steve Vaughn


Calculations and scripting language changes
Syntax is slightly different now
1 source fields are aways strings
a) no need to use "[F1]"
b) [F1]+[F2] will concatenate two fields
if you want to add them use conversion functions
StrtoFloat([F1])+StrtoFloat([F2])
2 use single quotes instead of double quotes
eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")
3 in order to make conversion easier we have added new menu item
"Correct calculations"
4 Lots of new functions, procedures and language changes (see documentation)

Re: New menu item "Correct calculations" 1 year, 3 months ago #1596

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
See picture below
menuitem.GIF
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

Within an hour we were able  to populate fact and dimension tables in our datawarehouse using Advanced ETL Processor

P. Jonson

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top