Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting variables into Field

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 

4 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

Thanks for reply !

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

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

sunny_talwar

What is the script you have so far?

Anonymous
Not applicable
Author

[Project1]:

LOAD

  "Id Project"

  ''Region''

here i want to use

Cost as NewCost ,

  

FROM [Project.qvd]

(qvd);