You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Two Ifs : to use in calculation script

Summary:


Content (required):

Hi

I want to use Two ifs in calculation scripts but it is giving a validation error.

Condition is if user selected a particular smartlist value : if("S0700270"->"OFS_Direct Input" == 1) and

if net profit before tax is a loss or positive : if("Net Profit before Tax_D_MAS"->"OFS_Calculated" > 0)


then condition to be written.



Following script errors out. Pls help.


"S0700273"

(

if("S0700270"->"OFS_Direct Input" == 1) and

if("Net Profit before Tax_D_MAS"->"OFS_Calculated" > 0)

"S0700273" = 

-(("Net Profit before Tax_D_MAS"->"OFS_Calculated"-

("55300008"->"All Cost Center"->"All Functional Area"->"Total Profit Center")+

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!