topic Manually Filed assignment to Numeric Columns (Expressions) in App Development

Manually Filed assignment to Numeric Columns (Expressions)

nayanpatel — Mon, 20 Dec 2021 21:08:46 GMT

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.

Re: Manually Filed assignment to Numeric Columns (Expressions)

sourabh808 — Wed, 15 Apr 2020 12:01:45 GMT

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

Re: Manually Filed assignment to Numeric Columns (Expressions)

Taoufiq_Zarra — Wed, 15 Apr 2020 12:02:12 GMT

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:

Re: Manually Filed assignment to Numeric Columns (Expressions)

nayanpatel — Wed, 15 Apr 2020 12:45:18 GMT

Thank you