conditional format using the IF function

I’m trying to use a conditional format using the IF function to determine if a value needs a dropdown menu.

Exp: if A1=book then provides a list of authors to choose from the same if A1=car then provide a list of automobile brands and so on for other options.

At the moment I’m having to use the formula in different columns:

Exp: Column B will have this formula =IF(A1=”books”, “Required”,””) and then add Conditional Format with a list of authors to choose from. Column C will have the formula =IF(A1=”car”, “Required”,””) then add Conditional Format with a list of automobile brands.

If there any way to have everything in one column that would be very helpful.

I would really appreciate any help on the subject.

list manipulation – Conditional column extraction

If column 2 is binary, you can use

Pick(A((All, {1, 3})), A((All, 2)), 0) (* or *)

Extract(A, Position(A((All, 2)), 0), #(({1, 3})) &) (* or *)

A((PositionIndex(A((All, 2)))@0, {1, 3}))

to get

{{1, 9}, {5, 6}, {7, 11}}

In general, you can wrap column 2 with Unitize:

Pick(A((All, {1, 3})), Unitize @ A((All, 2)), 0)

Extract(A, Position(Unitize @ A((All, 2)), 0), #(({1, 3})) &)

A((PositionIndex(Unitize(A((All, 2))))@0, {1, 3}))

Poisson Distribution and Conditional Probability

I’m stuck with a problem for my Statistics class. The problem says that there is a hospital where patients arrive at a constant rate of 2 patients per hour, and there is a doctor that works 12 hours, from 6 am to 6 pm. If the doctor has treated 6 patients by 8 am, what is the probability that he treats 9 patients by 10 am?

So, I was planning to solve this problem using Poisson distribution and conditional probability. I identified two events: A, where after 2 hours the doctor treats 6 patients, and B, where after 4 hours the doctor treats 9 patients.

For A, m=lambda*hours=2*2hrs=4, and P(X=6)= (e^-4 * 4^6)/6! = 0.104

For B, m=lambda*hours=2*4hrs=8, and P(X=9)= (e^-8 * 8^9)/9! = 0.124

So, given that events are independent in Poisson distributions, I try to calculate P(B|A) as P(B)/P(A) but I get a number > 1.

Also, I tried working the answer considering the time interval from 8 am to 10 pm, where the number of patients increased by (9-6)=3

In that scenario, m=lambda*hours=2*2hrs=4, and P(X=3)= (e^-4 * 4^3)/3! = 0.53 , but I think it must be wrong too, since it does not consider the event A.

Could someone help me with this?
Thanks!

google sheets – Conditional Formatting w/multiple conditions and partial text match

cells that do not match the conditions are getting highlighted and cells with the conditions are being omitted

That sound like you need a NOT to negate the result.

column C’s matching row begins with “EM”

The regular expression now matches all content which contains EM, so you probably need to replace the argument with "^EM"; the caret indicates the beginning of the content. (That’s a standard regex operator; as indicated here, Google Sheets uses the RE2 version.)

You could try this:

=not(and(regexmatch(C2,"^EM"),E2>1))

and see whether it works for you.

validation – How indicate conditional required field in editable table?

In a form indicating which fields are required are often indicated by an asterisk (*). We have an editable table and I indicate a required column with aesthetics in the title of the column.

The problem appears when initially no columns are required. But if the user fills one of the fields in the row, the next field in this row becomes mandatory and will not pass validation when the user will save the form. How to help the user and identify conditionally required fields?

enter image description here

enter image description here

8 – How add conditional required field

So, if dont want to use conditional_fields module and only conditional fields core
You can do it, but required field have sometime a little bug.

In the issue someone take some code from conditional_fields that fix this issue, and use it.

your_module/js/conditional_fields.js

(function ($, Drupal) {

// Fix core's required handling.
$(document).bind('state:required', function (e) {
  if (e.trigger) {
    var fields = $(e.target).find('input, select, textarea, fieldset');
    fields.each(function() {
      var label = 'label' + (this.id ? '(for=' + this.id + ')' : '');
      var $field_labels = $(e.target).find(label);
      var $fieldset_legends = $(e.target).find('legend span.fieldset-legend');
      var $labels = $field_labels.add($fieldset_legends);
      if (e.value) {
        $(this).attr({ required: 'required', 'aria-required': 'aria-required' });
        $labels.each(function() {
          $(this).addClass('js-form-required form-required');
        });
      } else {
        $(this).removeAttr('required aria-required');
        $labels.each(function() {
          $(this).removeClass('js-form-required form-required');
        });
      }
    })
  }
});

})(jQuery, Drupal);

In your_module.module in a form alter add:

$form('#attached')('library')() = 'your_module/conditional_fields';

$form('field_b')('#states') = (
      'visible' => (
        ':input(name="field_a")' => ('!value' => '_none')
      ),
      'required' => (
        ':input(name="field_a")' => ('!value' => '_none'),
      ),
  );

Don’t forget add the js code in your_module.libraries.yml file

Adding JS to a Drupal module

With our above code it worked!.

calculus and analysis – Derivative for conditional expectation of non-independent gaussian variables is increasing

Consider two non-independent gaussian random variables:
$$(t,c)∼text{BiNormal}((𝜇𝑡,𝜇𝑐),(𝜎𝑡,𝜎𝑐),𝜌)$$

I’m interested in understanding when (i.e. for which values of the distribution parameters) it’s true that $$frac{partial E(t |c<f(t)+x)}{partial x}>0$$
where

f(t_):=b*CDF(NormalDistribution(μa, σa), t)

What I’ve tried:

I’ve tried generating an analytical expression for the conditional
expectation, but this fails (output same as input)

Expectation(t (Conditioned) c < b*CDF(NormalDistribution(μa, σa), t) + x,
  {t, c} (Distributed) BinormalDistribution({μt, μc}, {σt, σc}, ρ))

I’ve also tried spelling out the expectation via integrals over the
joint distribution, and then taking derivatives. This does produce a
valid analytical output, but I cannot reduce the expression (error
message “This system cannot be solved with the methods available to
Reduce”
)

D(Integrate(t*PDF(BinormalDistribution({µt, µc}, {σt, σc}, ρ), {t, c}), 
  {c, -∞, CDF(NormalDistribution(µa, σa), t) + x}, {t, -∞, ∞})/
  Integrate(PDF(BinormalDistribution({µt, µc}, {σt, σc}, ρ), {t, c}), 
  {c, -∞, CDF(NormalDistribution(µa, σa), t) + x}, {t, -∞, ∞}), x)

Here is a related question on the analytical treatment of this problem: https://math.stackexchange.com/questions/3692958/parameters-for-which-conditional-expectation-of-non-independent-gaussian-variabl

google sheets – Conditional formatting if cell text matches one of multiple other checked cells texts

Finally, after literally 8+ hours of trying around, I found a solution.

First I filter all the Recipes that are checked with in cell I3

=FILTER(B3:B,C3:C=TRUE).

Then I use 2 conditional formatting formulas:

Forumla for A1:A

=AND(countif($I$3:$I,B3)>0,B3<>"")

Formula for D3:G7

=AND(countif($I$3:$I,D3)>0,D3<>"")

For anyone wondering, I use AND to include a second rule (D3<>””) to exclude blank cells from highlighting.

Can’t believe it was so easy..

This is how it looks now:
enter image description here

conditional – Replace the values of second position in a list with the values of another list given a condition

If I have the following two lists:

list1= https://pastebin.com/zFin7kkB

list2= https://pastebin.com/8ymCin6d

where the first element of both list is the same. How can I replace the values in the second position in list1 with the values of the sencond position of list2 multiplied by 1.2, only when the values of the first position in list1 and list2 are greater than 74?. For example, I would like to obtain a list that would look like: {{40,0.0712996},{40.,0.0712996},{40.,0.0712996}......{74.0202,0.0594163*1.2},{74.0404,0.059451*1.2},{74.0606,2.5}....etc. where 0.0594163*1.2, 0.059451*1.2 and 0.0594857*1.2 are the values of list2 at the same temperature greater than 74 multiplied by 1.2.

Thank you in advanced,

Conditional Sum using in XML

I am working on a RTF Template which has the below XML inserted in it.

    <?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle BI Publisher -Dataengine, datamodel:_Human_Capital_Management_Recruiting_Job_Offer_Data_Models_JobOfferLetterDM_xdm -->

-<DATA_DS>

<P_INTERNAL_ID/>

<P_OFFERID>300000048185676</P_OFFERID>

<P_OFFERLETTERTEMPLATENAME/>

<P_BIP_UUID/>


-<OFFER_DETAILS>

<OFFER_ID>300000048185676</OFFER_ID>

<JOB_OFFER_TITLE>USI Solution Consultant</JOB_OFFER_TITLE>

<CREATION_DATE>2020-05-22T17:56:36.660+00:00</CREATION_DATE>

<CREATED_BY>akhilesht</CREATED_BY>

<ACCEPTED_ON_BEHALF>N</ACCEPTED_ON_BEHALF>

<ACCEPTED_ON_BEHALF_BY/>

<ACCEPTED_ON_BEHALF_DATE/>

<COMMENTS/>

<PHASE>Offer</PHASE>

<STATE>Accepted</STATE>

<E_SIGNATURE_FULL_NAME>Andew Cota</E_SIGNATURE_FULL_NAME>

<E_SIGNATURE_SIGNEE_IP_ADDRESS>10.52.98.208</E_SIGNATURE_SIGNEE_IP_ADDRESS>

<E_SIGNATURE_SIGNATURE_DATE>2020-05-22T18:04:30.223+00:00</E_SIGNATURE_SIGNATURE_DATE>

<EXPIRATION_DATE/>

<ACCEPTED_DATE>2020-05-22T18:04:30.223+00:00</ACCEPTED_DATE>

<ADDITIONAL_TEXT_1/>

<ADDITIONAL_TEXT_2/>


-<E_SIGNATURE_STATEMENT>

-<![CDATA[<body> 
 <div>
   By signing this Agreement electronically, I agree that  my electronic signature is the legal equivalent of my manual signature.  
 </div> 
 <div> 
  <br /> 
 </div> 
 <div>
   I certify that all information is true and correct to the best of my knowledge. I also agree that no certification authority or other third party verification is necessary to validate my E-Signature and that the lack of such certification or third party verification will not in any way affect the enforceability of my E-Signature.    
 </div> 
</body>]]>
</E_SIGNATURE_STATEMENT>

<OFFER_DESCRIPTION> <![CDATA[ ]]></OFFER_DESCRIPTION>


-<OFFER_DATES>

<OFFER_ID>300000048185676</OFFER_ID>

<MOSTRECENTEXTENDEDDATE>2020-05-22T18:02:44.950+00:00</MOSTRECENTEXTENDEDDATE>

<MOSTRECENTWITHDRAWNDATE/>

</OFFER_DATES>


-<SALARY>

<SALARY_BASIS>INR Monthly Monthly Salary - India</SALARY_BASIS>

<SALARY_RANGE_HIGH/>

<SALARY_RANGE_MID/>

<SALARY_RANGE_LOW/>

<SALARY_AMOUNT>80500</SALARY_AMOUNT>

<COMPA_RATIO/>

<ANNUAL_SALARY>966000</ANNUAL_SALARY>

<ANNUAL_FULLTIME_SALARY>966000</ANNUAL_FULLTIME_SALARY>

<SALARY_RANGE_POSITION/>

<QUARTILE/>

<MULTIPLE_COMPONENTS>Y</MULTIPLE_COMPONENTS>

<OFFER_ID>300000048185676</OFFER_ID>

<GRADE_LADDER/>

<QUINTILE/>

<SALARY_CURRENCY_SYMBOL>₨</SALARY_CURRENCY_SYMBOL>

</SALARY>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Basic Salary</COMPONENT_NAME>

<COMPONENT_AMOUNT>40000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>HRA</COMPONENT_NAME>

<COMPONENT_AMOUNT>20000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Special Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Meal Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Education Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>NPS Adhoc Pay</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Monthly LTA</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Employer PF</COMPONENT_NAME>

<COMPONENT_AMOUNT>5000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Superannuation</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Car Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Gratuity</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Insurance Premium</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Housing Loan Subsidy</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPENSATION>

<PLAN_NAME>Guaranteed Bonus</PLAN_NAME>

<OPTION_NAME>Guaranteed Bonus - IN</OPTION_NAME>

<VALUE>50000</VALUE>

<UNITS>INR</UNITS>

<NON_MONETARY_UOM/>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPENS_CURRENCY_SYMBOL>₨</OTHER_COMPENS_CURRENCY_SYMBOL>

<OTHER_COMPENS_FREQUENCY>Once</OTHER_COMPENS_FREQUENCY>

<OTHER_COMPENS_START_DATE>2020-05-23T00:00:00.000+00:00</OTHER_COMPENS_START_DATE>

</OTHER_COMPENSATION>


-<OTHER_COMPENSATION>

<PLAN_NAME>Sign On Bonus</PLAN_NAME>

<OPTION_NAME>Sign On Bonus - India</OPTION_NAME>

<VALUE>10000</VALUE>

<UNITS>INR</UNITS>

<NON_MONETARY_UOM/>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPENS_CURRENCY_SYMBOL>₨</OTHER_COMPENS_CURRENCY_SYMBOL>

<OTHER_COMPENS_FREQUENCY>Once</OTHER_COMPENS_FREQUENCY>

<OTHER_COMPENS_START_DATE>2020-05-23T00:00:00.000+00:00</OTHER_COMPENS_START_DATE>

</OTHER_COMPENSATION>


-<ASSIGNMENT>

<ASSIGNMENT_NAME>Associate Solutions Consultant</ASSIGNMENT_NAME>

<LEGAL_EMPLOYER>Majesco Software and Solutions India Pvt. Limited</LEGAL_EMPLOYER>

<HIRE_DATE>2020-05-23T00:00:00.000+00:00</HIRE_DATE>

<WORKER_TYPE>Employee</WORKER_TYPE>

<BUSINESS_UNIT_NAME>Sales</BUSINESS_UNIT_NAME>

<JOB_NAME>Associate Solutions Consultant</JOB_NAME>

<GRADE>JB-3</GRADE>

<DEPARTMENT>Presales</DEPARTMENT>

<LOCATION_NAME>IN_Mahape Office</LOCATION_NAME>

<PROJECTED_END_DATE/>

<REGULAR_OR_TEMPORARY>Regular</REGULAR_OR_TEMPORARY>

<FULL_OR_PART_TIME>Full time</FULL_OR_PART_TIME>

<WORKING_HOURS>8.75</WORKING_HOURS>

<STANDARD_WORKING_HOURS/>

<FTE/>

<HEAD_COUNT/>

<CONTRACT_NAME/>

<CONTRACT_TYPE/>

<CONTRACT_DURATION/>

<CONTRACT_DURATION_UNIT/>

<CONTRACT_PROJECTED_END_DATE/>

<REPORTING_ESTABLISHMENT/>

<WORKING_AT_HOME/>

<WORKING_AS_A_MANAGER/>

<POSITION/>

<HOURLY_PAID_OR_SALARIED/>

<START_TIME>2020-05-23T00:00:00.000+00:00</START_TIME>

<END_TIME>4712-12-31T00:00:00.000+00:00</END_TIME>

<PROBATION_PERIOD/>

<NOTICE_PERIOD/>

<BARGAINING_UNIT/>

<COLLECTIVE_AGREEMENT/>

<UNION_MEMBER/>

<FORMATTED_SINGLE_LINE_ADDRESS>INDIA</FORMATTED_SINGLE_LINE_ADDRESS>

<FORMATTED_MULTI_LINE_ADDRESS>INDIA</FORMATTED_MULTI_LINE_ADDRESS>

<HR_ACTION>EMPL_OFFER_CREATE</HR_ACTION>

<OFFER_ID>300000048185676</OFFER_ID>

<WORKER_CATEGORY/>

<ASSIGNMENT_CATEGORY>Full-time regular</ASSIGNMENT_CATEGORY>

<ASSIGNMENT_ID>300000048185689</ASSIGNMENT_ID>

<GRADE_STEP/>

<ASSIGNMENT_START_DATE>2020-05-22T00:00:00.000+00:00</ASSIGNMENT_START_DATE>

<ASSIGNMENT_FREQUENCY>Daily</ASSIGNMENT_FREQUENCY>


-<ASSIGNMENT_FLEX_FIELDS>

<ASG_INFORMATION_DATE1/>

<ASG_INFORMATION_DATE2/>

<ASG_INFORMATION_DATE3/>

<ASG_INFORMATION_DATE4/>

<ASG_INFORMATION_DATE5/>

<ASG_INFORMATION_DATE6/>

<ASG_INFORMATION_DATE7/>

<ASG_INFORMATION_DATE8/>

<ASG_INFORMATION_DATE9/>

<ASG_INFORMATION_DATE10/>

<ASG_INFORMATION_DATE11/>

<ASG_INFORMATION_DATE12/>

<ASG_INFORMATION_DATE13/>

<ASG_INFORMATION_DATE14/>

<ASG_INFORMATION_DATE15/>

<ASS_ATTRIBUTE_DATE1/>

<ASS_ATTRIBUTE_DATE2/>

<ASS_ATTRIBUTE_DATE3/>

<ASS_ATTRIBUTE_DATE4/>

<ASS_ATTRIBUTE_DATE5/>

<ASS_ATTRIBUTE_DATE6/>

<ASS_ATTRIBUTE_DATE7/>

<ASS_ATTRIBUTE_DATE8/>

<ASS_ATTRIBUTE_DATE9/>

<ASS_ATTRIBUTE_DATE10/>

<ASS_ATTRIBUTE_DATE11/>

<ASS_ATTRIBUTE_DATE12/>

<ASS_ATTRIBUTE_DATE13/>

<ASS_ATTRIBUTE_DATE14/>

<ASS_ATTRIBUTE_DATE15/>

<ASG_INFORMATION1/>

<ASG_INFORMATION2/>

<ASG_INFORMATION3/>

<ASG_INFORMATION4/>

<ASG_INFORMATION5/>

<ASG_INFORMATION6/>

<ASG_INFORMATION7/>

<ASG_INFORMATION8/>

<ASG_INFORMATION9/>

<ASG_INFORMATION10/>

<ASG_INFORMATION11/>

<ASG_INFORMATION12/>

<ASG_INFORMATION13/>

<ASG_INFORMATION14/>

<ASG_INFORMATION15/>

<ASG_INFORMATION16/>

<ASG_INFORMATION17/>

<ASG_INFORMATION18/>

<ASG_INFORMATION19/>

<ASG_INFORMATION20/>

<ASG_INFORMATION21/>

<ASG_INFORMATION22/>

<ASG_INFORMATION23/>

<ASG_INFORMATION24/>

<ASG_INFORMATION25/>

<ASG_INFORMATION26/>

<ASG_INFORMATION27/>

<ASG_INFORMATION28/>

<ASG_INFORMATION29/>

<ASG_INFORMATION30/>

<ASG_INFORMATION31/>

<ASG_INFORMATION32/>

<ASG_INFORMATION33/>

<ASG_INFORMATION34/>

<ASG_INFORMATION35/>

<ASG_INFORMATION36/>

<ASG_INFORMATION37/>

<ASG_INFORMATION38/>

<ASG_INFORMATION39/>

<ASG_INFORMATION40/>

<ASG_INFORMATION41/>

<ASG_INFORMATION42/>

<ASG_INFORMATION43/>

<ASG_INFORMATION44/>

<ASG_INFORMATION45/>

<ASG_INFORMATION46/>

<ASG_INFORMATION47/>

<ASG_INFORMATION48/>

<ASG_INFORMATION49/>

<ASG_INFORMATION50/>

<ASS_ATTRIBUTE1/>

<ASS_ATTRIBUTE2/>

<ASS_ATTRIBUTE3/>

<ASS_ATTRIBUTE4/>

<ASS_ATTRIBUTE5/>

<ASS_ATTRIBUTE6/>

<ASS_ATTRIBUTE7/>

<ASS_ATTRIBUTE8/>

<ASS_ATTRIBUTE9/>

<ASS_ATTRIBUTE10/>

<ASS_ATTRIBUTE11/>

<ASS_ATTRIBUTE12/>

<ASS_ATTRIBUTE13/>

<ASS_ATTRIBUTE14/>

<ASS_ATTRIBUTE15/>

<ASS_ATTRIBUTE16/>

<ASS_ATTRIBUTE17/>

<ASS_ATTRIBUTE18/>

<ASS_ATTRIBUTE19/>

<ASS_ATTRIBUTE20/>

<ASS_ATTRIBUTE21/>

<ASS_ATTRIBUTE22/>

<ASS_ATTRIBUTE23/>

<ASS_ATTRIBUTE24/>

<ASS_ATTRIBUTE25/>

<ASS_ATTRIBUTE26/>

<ASS_ATTRIBUTE27/>

<ASS_ATTRIBUTE28/>

<ASS_ATTRIBUTE29/>

<ASS_ATTRIBUTE30/>

<ASS_ATTRIBUTE31/>

<ASS_ATTRIBUTE32/>

<ASS_ATTRIBUTE33/>

<ASS_ATTRIBUTE34/>

<ASS_ATTRIBUTE35/>

<ASS_ATTRIBUTE36/>

<ASS_ATTRIBUTE37/>

<ASS_ATTRIBUTE38/>

<ASS_ATTRIBUTE39/>

<ASS_ATTRIBUTE40/>

<ASS_ATTRIBUTE41/>

<ASS_ATTRIBUTE42/>

<ASS_ATTRIBUTE43/>

<ASS_ATTRIBUTE44/>

<ASS_ATTRIBUTE45/>

<ASS_ATTRIBUTE46/>

<ASS_ATTRIBUTE47/>

<ASS_ATTRIBUTE48/>

<ASS_ATTRIBUTE49/>

<ASS_ATTRIBUTE50/>

<ASS_ATTRIBUTE_NUMBER1/>

<ASS_ATTRIBUTE_NUMBER2/>

<ASS_ATTRIBUTE_NUMBER3/>

<ASS_ATTRIBUTE_NUMBER4/>

<ASS_ATTRIBUTE_NUMBER5/>

<ASS_ATTRIBUTE_NUMBER6/>

<ASS_ATTRIBUTE_NUMBER7/>

<ASS_ATTRIBUTE_NUMBER8/>

<ASS_ATTRIBUTE_NUMBER9/>

<ASS_ATTRIBUTE_NUMBER10/>

<ASS_ATTRIBUTE_NUMBER11/>

<ASS_ATTRIBUTE_NUMBER12/>

<ASS_ATTRIBUTE_NUMBER13/>

<ASS_ATTRIBUTE_NUMBER14/>

<ASS_ATTRIBUTE_NUMBER15/>

<ASS_ATTRIBUTE_NUMBER16/>

<ASS_ATTRIBUTE_NUMBER17/>

<ASS_ATTRIBUTE_NUMBER18/>

<ASS_ATTRIBUTE_NUMBER19/>

<ASS_ATTRIBUTE_NUMBER20/>

<ASS_ATTRIBUTE_CATEGORY/>

<ASSIGNMENT_ID>300000048185689</ASSIGNMENT_ID>

</ASSIGNMENT_FLEX_FIELDS>

</ASSIGNMENT>


-<OFFER_RECIPIENT>

<DISPLAY_NAME>Andew Cota</DISPLAY_NAME>

<PERSONAL_EMAIL_ADDRESS>shivamkumar07+12@gmail.com</PERSONAL_EMAIL_ADDRESS>

<WORK_EMAIL_ADDRESS/>

<WORK_PHONE_NUMBER/>

<PERSONAL_PHONE_NUMBER/>

<HOME_ADDRESS/>

<CANDIDATE_TYPE>ORA_EXTERNAL_CANDIDATE</CANDIDATE_TYPE>

<PERSON_NUMBER/>

<OFFER_ID>300000048185676</OFFER_ID>

<RECIPIENT_FULL_NAME>Cota, Andew</RECIPIENT_FULL_NAME>

<RECIPIENT_FIRST_NAME>Andew</RECIPIENT_FIRST_NAME>

<RECIPIENT_LAST_NAME>Cota</RECIPIENT_LAST_NAME>

<RECIPIENT_INITIALS>AC</RECIPIENT_INITIALS>

<RECIPIENT_JOB_TITLE/>

</OFFER_RECIPIENT>


-<TEAM_MEMBER_HIRING_MANAGER>

<OFFER_ID>300000048185676</OFFER_ID>

<HIRING_MANAGER_FIRST_NAME>Amit</HIRING_MANAGER_FIRST_NAME>

<HIRING_MANAGER_LAST_NAME>Doshi</HIRING_MANAGER_LAST_NAME>

<HIRING_MANAGER_FULL_NAME>Amit Doshi</HIRING_MANAGER_FULL_NAME>

<HIRING_MANAGER_JOB_TITLE>Principal Solution Consultant</HIRING_MANAGER_JOB_TITLE>

<HIRING_MANAGER_WORK_EMAIL>test_AMIT.DOSHI@MAJESCO.COM</HIRING_MANAGER_WORK_EMAIL>

<HIRING_MANAGER_WORK_PHONE>1324</HIRING_MANAGER_WORK_PHONE>

<HIRING_MANAGER_INITIALS>AD</HIRING_MANAGER_INITIALS>

</TEAM_MEMBER_HIRING_MANAGER>


-<TEAM_MEMBER_RECRUITER>

<OFFER_ID>300000048185676</OFFER_ID>

<RECRUITER_FIRST_NAME>Akhilesh</RECRUITER_FIRST_NAME>

<RECRUITER_LAST_NAME>Tandel</RECRUITER_LAST_NAME>

<RECRUITER_FULL_NAME>Akhilesh Tandel</RECRUITER_FULL_NAME>

<RECRUITER_JOB_TITLE>VP, Strategy and Solutions</RECRUITER_JOB_TITLE>

<RECRUITER_WORK_EMAIL>test_AKHILESH.TANDEL@MAJESCO.COM</RECRUITER_WORK_EMAIL>

<RECRUITER_WORK_PHONE>1612</RECRUITER_WORK_PHONE>

<RECRUITER_INITIALS>AT</RECRUITER_INITIALS>

</TEAM_MEMBER_RECRUITER>


-<TEAM_MEMBER_COLLABORATORS>

<OFFER_ID>300000048185676</OFFER_ID>

<COLLABORATOR_FIRST_NAME>Amit</COLLABORATOR_FIRST_NAME>

<COLLABORATOR_LAST_NAME>Kumar</COLLABORATOR_LAST_NAME>

<COLLABORATOR_FULL_NAME>Amit Kumar</COLLABORATOR_FULL_NAME>

<COLLABORATOR_JOB_TITLE/>

<COLLABORATOR_WORK_EMAIL>shbahadur@deloitte.com</COLLABORATOR_WORK_EMAIL>

<COLLABORATOR_WORK_PHONE>1355</COLLABORATOR_WORK_PHONE>

<COLLABORATOR_INITIALS>AK</COLLABORATOR_INITIALS>

</TEAM_MEMBER_COLLABORATORS>


-<REQUISITION_DETAILS>

<REQUISITION_TITLE>USI Solution Consultant</REQUISITION_TITLE>

<REQUISITION_NUMBER>171</REQUISITION_NUMBER>

<RECRUITING_TYPE>Professional</RECRUITING_TYPE>

<OTHER_TITLE/>

<OPENINGS>5</OPENINGS>

<NUMBER_HIRED/>

<OFFER_ID>300000048185676</OFFER_ID>

</REQUISITION_DETAILS>


-<OFFER_FLEX_FIELDS>

<ATTRIBUTE_TIMESTAMP1/>

<ATTRIBUTE_TIMESTAMP2/>

<ATTRIBUTE_TIMESTAMP3/>

<ATTRIBUTE_TIMESTAMP4/>

<ATTRIBUTE_TIMESTAMP5/>

<ATTRIBUTE_TIMESTAMP6/>

<ATTRIBUTE_TIMESTAMP7/>

<ATTRIBUTE_TIMESTAMP8/>

<ATTRIBUTE_TIMESTAMP9/>

<ATTRIBUTE_TIMESTAMP10/>

<ATTRIBUTE_DATE1/>

<ATTRIBUTE_DATE2/>

<ATTRIBUTE_DATE3/>

<ATTRIBUTE_DATE4/>

<ATTRIBUTE_DATE5/>

<ATTRIBUTE_DATE6/>

<ATTRIBUTE_DATE7/>

<ATTRIBUTE_DATE8/>

<ATTRIBUTE_DATE9/>

<ATTRIBUTE_DATE10/>

<ATTRIBUTE_NUMBER1/>

<ATTRIBUTE_NUMBER2/>

<ATTRIBUTE_NUMBER3/>

<ATTRIBUTE_NUMBER4/>

<ATTRIBUTE_NUMBER5/>

<ATTRIBUTE_NUMBER6/>

<ATTRIBUTE_NUMBER7/>

<ATTRIBUTE_NUMBER8/>

<ATTRIBUTE_NUMBER9/>

<ATTRIBUTE_NUMBER10/>

<ATTRIBUTE_NUMBER11/>

<ATTRIBUTE_NUMBER12/>

<ATTRIBUTE_NUMBER13/>

<ATTRIBUTE_NUMBER14/>

<ATTRIBUTE_NUMBER15/>

<ATTRIBUTE_NUMBER16/>

<ATTRIBUTE_NUMBER17/>

<ATTRIBUTE_NUMBER18/>

<ATTRIBUTE_NUMBER19/>

<ATTRIBUTE_NUMBER20/>

<ATTRIBUTE_CHAR1>Y</ATTRIBUTE_CHAR1>

<ATTRIBUTE_CHAR2>Office Location</ATTRIBUTE_CHAR2>

<ATTRIBUTE_CHAR3/>

<ATTRIBUTE_CHAR4>2000</ATTRIBUTE_CHAR4>

<ATTRIBUTE_CHAR5/>

<ATTRIBUTE_CHAR6>1000</ATTRIBUTE_CHAR6>

<ATTRIBUTE_CHAR7/>

<ATTRIBUTE_CHAR8/>

<ATTRIBUTE_CHAR9/>

<ATTRIBUTE_CHAR10/>

<ATTRIBUTE_CHAR11/>

<ATTRIBUTE_CHAR12/>

<ATTRIBUTE_CHAR13/>

<ATTRIBUTE_CHAR14/>

<ATTRIBUTE_CHAR15/>

<ATTRIBUTE_CHAR16/>

<ATTRIBUTE_CHAR17/>

<ATTRIBUTE_CHAR18/>

<ATTRIBUTE_CHAR19/>

<ATTRIBUTE_CHAR20/>

<ATTRIBUTE_CHAR21/>

<ATTRIBUTE_CHAR22/>

<ATTRIBUTE_CHAR23/>

<ATTRIBUTE_CHAR24/>

<ATTRIBUTE_CHAR25/>

<ATTRIBUTE_CHAR26/>

<ATTRIBUTE_CHAR27/>

<ATTRIBUTE_CHAR28/>

<ATTRIBUTE_CHAR29/>

<ATTRIBUTE_CHAR30/>

<ATTRIBUTE_CATEGORY/>

<OFFER_ID>300000048185676</OFFER_ID>

<ATTRIBUTE_NUMBER21/>

<ATTRIBUTE_NUMBER22/>

<ATTRIBUTE_NUMBER23/>

<ATTRIBUTE_NUMBER24/>

<ATTRIBUTE_NUMBER25/>

<ATTRIBUTE_NUMBER26/>

<ATTRIBUTE_NUMBER27/>

<ATTRIBUTE_NUMBER28/>

<ATTRIBUTE_NUMBER29/>

<ATTRIBUTE_NUMBER30/>

<ATTRIBUTE_CHAR31/>

<ATTRIBUTE_CHAR32/>

<ATTRIBUTE_CHAR33/>

<ATTRIBUTE_CHAR34/>

<ATTRIBUTE_CHAR35/>

<ATTRIBUTE_CHAR36/>

<ATTRIBUTE_CHAR37/>

<ATTRIBUTE_CHAR38/>

<ATTRIBUTE_CHAR39/>

<ATTRIBUTE_CHAR40/>

<ATTRIBUTE_CHAR41/>

<ATTRIBUTE_CHAR42/>

<ATTRIBUTE_CHAR43/>

<ATTRIBUTE_CHAR44/>

<ATTRIBUTE_CHAR45/>

<ATTRIBUTE_CHAR46/>

<ATTRIBUTE_CHAR47/>

<ATTRIBUTE_CHAR48/>

<ATTRIBUTE_CHAR49/>

<ATTRIBUTE_CHAR50/>

<ATTRIBUTE_CHAR51/>

<ATTRIBUTE_CHAR52/>

<ATTRIBUTE_CHAR53/>

<ATTRIBUTE_CHAR54/>

<ATTRIBUTE_CHAR55/>

<ATTRIBUTE_CHAR56/>

<ATTRIBUTE_CHAR57/>

<ATTRIBUTE_CHAR58/>

<ATTRIBUTE_CHAR59/>

<ATTRIBUTE_CHAR60/>

<ATTRIBUTE_CHAR61/>

<ATTRIBUTE_CHAR62/>

<ATTRIBUTE_CHAR63/>

<ATTRIBUTE_CHAR64/>

<ATTRIBUTE_CHAR65/>

<ATTRIBUTE_CHAR66/>

<ATTRIBUTE_CHAR67/>

<ATTRIBUTE_CHAR68/>

<ATTRIBUTE_CHAR69/>

<ATTRIBUTE_CHAR70/>

<ATTRIBUTE_CHAR71/>

<ATTRIBUTE_CHAR72/>

<ATTRIBUTE_CHAR73/>

<ATTRIBUTE_CHAR74/>

<ATTRIBUTE_CHAR75/>

<ATTRIBUTE_CHAR76/>

<ATTRIBUTE_CHAR77/>

<ATTRIBUTE_CHAR78/>

<ATTRIBUTE_CHAR79/>

<ATTRIBUTE_CHAR80/>

<ATTRIBUTE_CHAR81/>

<ATTRIBUTE_CHAR82/>

<ATTRIBUTE_CHAR83/>

<ATTRIBUTE_CHAR84/>

<ATTRIBUTE_CHAR85/>

<ATTRIBUTE_CHAR86/>

<ATTRIBUTE_CHAR87/>

<ATTRIBUTE_CHAR88/>

<ATTRIBUTE_CHAR89/>

<ATTRIBUTE_CHAR90/>

</OFFER_FLEX_FIELDS>

</OFFER_DETAILS>

</DATA_DS>

Now I want to do addition/SUM of all COMPONENT_AMOUNT where COMPONENT_NAME = ‘Basic Salary & HRA & Special Adhoc Allowance & Meal Allowance & Education Allowance & NPS Adhoc Pay & Adhoc Allowance & Monthly LTA’

Can any anyone please help me to understand how this can be achieved ?

Thanks,
Shivam