How could i calculate SESSI from below scenario?????

[wasem_hassan]

Hi folks,

How could be achieve below scenario as attached screen shot

I have to calculate SESSI

IF Monthly Gross Salary < Minimum wage Then Monthly Gross Salary* Multiplier rate to obtain SESSI otherwise blank.

Please advice me Asap.

Regards,

Wasem

[david_ings]

Hi Wasem,

Scope in Monthly Gross Salary with XDIM_MEMBERSETs.

Then REC line similar to below:

*REC(EXPRESSION=%VALUE%<([ACCOUNT].[AC_MIN_WAGE]) ? %VALUE%*([ACCOUNT].[AC_MULTIPLIER_RATE]):0,ACCOUNT=AC_SESSI)

Or if you want the alternative to be nothing rather than zero, then write destination over destination.

See http://scn.sap.com/thread/3889915 for example from Vadim on this last part.

David

[wasem_hassan]

Thanks David from your side some input.But am still not get result.

[wasem_hassan]

Hi David ,

Here Multiply rate is not part of account . Its just like input .

So how could solve it.

Regards,

Wasem

[former_member186338]

If rate is not a member of account - just a cell in the input form then you have to pass it to DM package manually or using VBA code...

[wasem_hassan]

Thanks Vadim, Could you please share any docs for related means how to pass values through DM package . so i will implement easily.

Regards,

Wasem

[former_member186338]

When you launch DM package the user will be asked to select or enter values/members. It's defined in DM advanced script. Just help: Prompt Commands - SAP BusinessObjects Planning and Consolidation - SAP Library

To pass rate value use something like:

PROMPT(TEXT,%RATE%,"Enter rate")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,RATE%EQU%%RATE%)

In the script you will use $RATE$ variable

Vadim

[wasem_hassan]

Thanks Vadim for swift reply.

Regards,

Wasem

[wasem_hassan]

Hi Vadim,

Could you help me how could i define $RATE$ variable in my logic script.

Pls advice me  with some dummy lgs

Regards,

Wasem

[former_member186338]

Sorry Wasem,

You have to read at least some basic info about script logic:

You don't need to define $RATE$ variable, it's defined in the advanced script. In script logic you just use it: like %VALUE%*$RATE$

Vadim

[wasem_hassan]

Thanks Vadim

For quick response .

Actually i want to calculate on input from user through DM . earlier post u have mentioned ,  in the script you will use $RATE$ variable. whats why am asking you. So , i can easily develop lgs as based on my scenario .

Regards

Wasem

[former_member186338]

Ups, not enough info...

How do you want to calculate it: using Excel formulas or script logic?

Vadim

[former_member186338]

ASAP and... silence

[wasem_hassan]

Hi Vadim,

Thanks for swift reply.I want to calculate through logic script not in excel.Ps advice me.

Regards

Wasem

[former_member186338]

For logic script you have to answer questions posted here:

[wasem_hassan]

Hi,

I gone through that doc. but I still didn't get exact solution.

[former_member186338]

The document is not about solution, it's about the information required to get some help!