calculated dimension pivot and straight table showing zero

[arulsettu]

Hi,

     Below two calcluated dimensions i used in pivot and straight table. its showing first record acc name acc code starts with zero. i enabled supress when values is null in diemnsion tab but no use.

=if(ACNT_FLAG='C',ACNT_FLAG='M',ACNT_CODE)

=if(ACNT_FLAG='C',ACNT_FLAG='M',ACNT_NAME)

some one suggest some way to avoid it.

Thank you

[sunny_talwar]

Arul I don't completely understand what you are looking for, would you be able to share a sample or may be some screenshots to show what is going wrong?

Best,

Sunny

[MK_QSL]

Try

=IF(ACNT_CODE = 'C' or ACNT_CODE = 'M',ACNT_CODE)

[jonathandienst]

What is the expression supposed to achieve? If the first clause is true (ACNT_FLAG='C'), then it will return the second clause (ACNT_FLAG='M') which will always be false (0). I guess what you want is (in psuedo code)

          if ACNT_FLG = 'C' or 'M' then ACNT_CODE else nothing

And in QV code

          if(Match(ACNT_FLG, 'A', 'C'), ACNT_CODE)

Now suppress nulls should work

[arulsettu]

hi Sunny,

above calculated dimesion i used in straight table

plz check the image i am getting 0 value in acc code and acc name i want to avoid it

[arulsettu]

need to display both C and M records

[arulsettu]

Hi Manish bro,

               it works but total value is wrong. i will upload sample app

Thanks

[arulsettu]

plz check this app in this table invidual record values are correct but total is incorrect

plz check opeing balance column in the straight table

[sunny_talwar]

Nothing shows up when I open the application.

[arulsettu]

app size is around 50 mb i reduced all data sunny