topic Re: Converting variables into Field in App Development

Converting variables into Field

Anonymous — Fri, 10 Nov 2017 15:20:17 GMT

hello Guys,

Needed help .

I have created a variable

SET COST= A(expression) +B( expression) ;

Now i need to use COST in the script as a field , How do i convert it ?

I need something like this :-

COST as NewCost field so that I can use NewCost for my further calculation.

Kindly help .

Thanks,

Ravi

sunny_talwar — Fri, 10 Nov 2017 15:24:21 GMT

What is A and B here? field names or some kind of calculations with functions such as Sum, Min, Max, Avg?

Anonymous — Fri, 10 Nov 2017 15:31:36 GMT

Thanks for reply !

Set Cost= (Count({$<Winstatus={'Lost'}>} distinct Winproject)

+ Count({$<Winstatus={'Canceled'}>} distinct Winproject));

sunny_talwar — Fri, 10 Nov 2017 15:49:14 GMT

What is the script you have so far?

Anonymous — Fri, 10 Nov 2017 16:35:59 GMT

[Project1]:

LOAD

"Id Project"

''Region''

here i want to use

Cost as NewCost ,

FROM [Project.qvd]

(qvd);