Custom Measure Formulae

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Custom Measure Formulae

Postby umerqadir » Thu Jun 21, 2007 4:48 am

what are the set of functions that we can use in a custom measure can I do something like this this doesnt seem to be working

begin
Result = MAXIMUM(1,2)
end


begin
Result = MAX(1,2)
end
umerqadir
User
 
Posts: 6
Joined: Wed Aug 23, 2006 6:41 am

Postby AlexZencovich » Thu Jun 21, 2007 5:23 am

List of supported functions:

SQRT(value)
ABS(value)
SIN(value)
COS(value)
POWER(value, power)
POWER2(value)
LOG10(value)
LN(value)
EXP(value)
NEG(value)


Example

begin
var a;
var b;
func xy;
a = "Summa";
b = "Count";
Result = xy( a , b );
end
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 3 guests

cron