^ or Power() in update data expression

Avatar

Avatar

Idde1969

Avatar

Idde1969

Idde1969

15-02-2019

Hi.

I am trying to update a field with data using either ^ or the Power() funtion.

Floor(Random() *  2 ^ $(vars/@varNoOfGroups))

Genertates a GUI error and

Floor(Random() *  Power(2, $(vars/@varNoOfGroups)))

Generates an error in the Journal

2019-02-15 10:54:12 writer XTK-170016 You are not authorized to use SQL expressions. 'Power' cannot be processed.

Any clue on how to solve this. Tried to add the named right SQL SCRIPT EXECUTION to my user

Best regards,

Martin

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

15-02-2019

Hi,

Follow this guide:

Thanks,

-Jon

Answers (0)