cancel
Showing results for 
Search instead for 
Did you mean: 

Script logic - how to test for entry of "" (nothing)

Former Member
0 Kudos

Hi,

I have a bit of logic that checks whether an account (METHOD) has certain values and then records a value onto a different account. This works fine, except for cases where a user changes the current value of METHOD to nothing, i.e. deletes the value in an input schedule and then saves it.

My script is



*SELECT(%GROUPS%,[ID],ConsolView,"CURRENCY_TYPE='G'")

*XDIM_MEMBERSET OWNACCOUNT=METHOD,PCON,PMIN,PGROUP
*XDIM_MEMBERSET CONSOLVIEW=%GROUPS%

*WHEN OWNACCOUNT
*IS "METHOD"
*WHEN GET(OWNACCOUNT="METHOD")
*IS "90"
*REC(EXPRESSION=(1-GET(OWNACCOUNT="PCON")),OWNACCOUNT="PMIN")
...

There are a few more *IS statements after this one which are checking for different values.

I then tried this


*IS ""
*REC(EXPRESSION=0,OWNACCOUNT="PGROUP")

the idea is that when the current value in METHOD is deleted, a zero value should be recorded on PGROUP, but that does not work.

In my mind the problem is the *IS"" but I have no idea how else to write it.

Thanks for any help in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Arnold

Could you please give me some info about "GET" keyword.

Thanks in advance

Former Member
0 Kudos

With the GET keyword you can check for a value on a dimension member, in my case I

first select the account called METHOD from my account structure (which is OWNACCOUNT)

second I check for the value stored on that account

Former Member
0 Kudos

found a solution