Current Position:Home > How to apply Excel formula in BPS layout

How to apply Excel formula in BPS layout

Update:11-30Source: network consolidation
Advertisement
Hi ,
   I need to apply the following logic in my BPS layout.
There are three data columns called C,D,E respectivelt
redord 1   user input data for all the columns,
Record 2   C2 = D1 + E2.
Record 3   C3 = D2 + E3.
Record n   Cn = D(n-1) + En.
  n is the number of record in teh layout.
1: Can we use Excel formula to achive this?
2: If the anser is yes, how can we configure the BPS layout? I am not sure if we can do it at the last step of change layout.
3: If the answer is no, what is the other choice? I have tried to use user exit, but had some problem in passing the data to xth_data table in the orginal order sequence.
thanks in advance.

The Best Answer

Advertisement
JW,
please see my answer to your original post "data in BPS layout columns"
Regards,
Marc
SAP NetWeaver RIG
  • How to apply Excel formula in BPS layout Update:11-30

    Hi ,    I need to apply the following logic in my BPS layout. There are three data columns called C,D,E respectivelt redord 1   user input data for all the columns, Record 2   C2 = D1 + E2. Record 3   C3 = D2 + E3. Record n   Cn = D(n-1) + En.   n is

  • Formulas in BPS Layout Update:11-30

    Hi, I have a BPS layout, I had needed to include formulas with visual basic to some columns, and these are saved in the transactional cube. My problem is, with the time, the data for the column that has the formula can change.  When that occurs, data

  • Excel functionality in BPS layout Update:11-30

    Hi gurus, I have a problem with layout on excel: all the excel functionality are not avaible, in particular i refer to filter and order. I try to unprotect excel worksheet but if i use filter i have a lot of problems when save data. My users are very

  • Loading data from excel to BPS layout Update:10-11

    Hi, I have BPS layouts in place and also excel sheets which are exact replica of those layouts. I know 2 options to load excel data into the BPS. These are: 1) Copy and paste the data from excel to BPS layout. 2) Create a flat file in line format fro

  • Saving Excel formula's in BPS Layout Update:11-30

    Dear All, I am trying to save  the formula's in BPS Layout, but its not saving , I presume these formula's will not save in cubes, Can anyone advise me the best solution for calculations in excel based layout, OR do i need to use fox formula's instea

  • Check user manual input in excel BPS layouts Update:11-30

    I have some problems for manual input characteristics checks on an excel bps layout. I need to assign the value of an header characteristic to a detaild characteristic. How can I do ? I have already tried with characteristic rels. (exit, attributes,

  • Hierarchies in excel  BPS Layout Update:11-30

    Hi All, I have created Cost Element hierarchies in RSH1 , Permanenet Salaries(Text Node) 1000 (Cost ELements)   2000   3000 Sub total Training(Text Nodes) 1100(Cost ELements) 1200 1300 Sub total In selection tab of Planning area i have assigned my hi

  • Data columns in BPS layout Update:11-30

    Hi,   My current BPS layout has three columns, they are cost,price and margin respectively. The user now ask to add another column call "alert" after the margin column. The logic is that if the margin is less than 10%, then the alert column shou

  • Data in BPS layout columns Update:11-30

    Hi,    I have two data columns in my BPS layout called price and margin with one lead column material, the layout looks like this when it initially display:    Material    Price   margin       1          1.25       2       3       4 The requirments i

  • Total in BPS Layout Update:11-30

    Hi All, I want to add a line for total in a BPS layout. In BPS0 transaction, there is a button that allowed to add line for total in the Excel sheet. The problem is that line don't appear in the layout of the campaign in CRM. Could you please help me