Expand my Community achievements bar.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

^ or Power() in update data expression

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

Follow this guide:

Thanks,

-Jon