Manually Filed assignment to Numeric Columns (Expressions)

[nayanpatel]

Hi Friends,

I have a table Contains columns(ID,Opening,Need Identification,Product Presentation) etc. as attached in screenshot

Now, I want to map some external filed called Status to that columns and show sum.

Please help.

Expected output is attached here

Thank you.

[sourabh808]

Hello Nayan ,

Table1:

Load

'Opening' as Status,

Id,

##_opening as Total

from xyz;

Load

'Need Identification' as Status,

Id,

##Need_Identification as Total

from xyz;

Load

'Product Presentation' as Status,

Id,

##Product_Presentation as Total

from xyz;

You can plot them in a table and you have your expected output.

Regards,

Sourabh

[Taoufiq_Zarra · Accepted solution]

attached

you can use ValueList :

Status :

=ValueList('OPENNING','NEED IDENTIFICATION','PRODUCT PRESENTATION','NEGOTIATION')

Total:

=If(ValueList('OPENNING','NEED IDENTIFICATION','PRODUCT PRESENTATION','NEGOTIATION')= 'OPENNING',
sum([##_OPENING]),
if(ValueList('OPENNING','NEED IDENTIFICATION','PRODUCT PRESENTATION','NEGOTIATION')= 'NEED IDENTIFICATION',
sum([##_NEED IDENTIFICATION]),
if(ValueList('OPENNING','NEED IDENTIFICATION','PRODUCT PRESENTATION','NEGOTIATION')= 'PRODUCT PRESENTATION',
sum([##_PRODUCT PRESENTATION]),
if(ValueList('OPENNING','NEED IDENTIFICATION','PRODUCT PRESENTATION','NEGOTIATION')= 'NEGOTIATION',sum([##_NEGOTIATION])
))))

output:

[nayanpatel · Accepted solution]

Thank you