Skip to Content
0
Former Member
Dec 30, 2011 at 10:12 AM

A Simple measure formula(why wont it work??)

25 Views

Hello Gurus,

Here is a simple formula I have written. It will show 1 just fine when its Non asset accounts with Datasrc dimension member of other than CTA, but it shows just blank when the IIF condition is met(AST account and datasrc CTA). Why is that? Here are all the steps I am taking:

1 - go to dbo.measureformula table and change the statement

2 - process the application

3 - reopen the report

Please advise.

IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="AST" AND DATASRC.CURRENTMEMBER.PROPERTIES("ID")="CTA",(MEASURES.[SIGNEDDATA]),1)

NOTE: I know this measure doesnt make a whole lot of sense, Why 1 for all other data intersections? this is just a simple example to resolve the issue, the actual formula is much more complex. thanks.

Edited by: ZalakT on Dec 30, 2011 5:12 AM