Skip to Content
0
Apr 17, 2014 at 09:29 PM

Null Records in scope when comparing category data

23 Views

I have a (what i thought would be a simple) script to compare 2 sets of data in 2 category members.

*SELECT (%TIME%,"[ID]", TIME, "[CURRENTPERIODS] = 'CURRENT_MONTH'")
*XDIM_MEMBERSET TIME = %TIME%
*XDIM_MEMBERSET ACCOUNT AS %ACCT% = BAS(ACCOUNT)
*XDIM_MEMBERSET ACCOUNT = %ACCT%
*XDIM_MEMBERSET CATEGORY = V1
*XDIM_ADDMEMBERSET CATEGORY = V2


*WHEN CATEGORY
*IS V1
*REC(EXPRESSION = %VALUE% - ([CATEGORY].[V2]), ACCOUNT = DELTA, VERSION = V2)
*ENDWHEN

Script works great when there is a value in V1 but when their is nothing in V1 but data in V2 i don't get

a resulting value. How can I force/trick it to see a value in V1 (even 0) so i will get a result?