Logic correction

[nareshthavidishetty]

Hi,

I have used the below logic in calculated dimension.But i'm getting common value to all the dimensions.

Please find below for reference.

Logic:

=aggr(num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales))

/(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)

+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales)),' #,##0.0%'),Loc)

Thanks..

[MK_QSL]

Try this...

num(

  (sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

  /

  (

  sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)

  +

  sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales)

  +

  sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

  )

  ,' #,##0.0%')

[MK_QSL]

or this

num(

  (sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

  /

  (

  sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'Wet Sign'}>}Sales)

  +

  sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales)

  +

  sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales)

  )

  ,' #,##0.0%')

[nareshthavidishetty]

Hi ,

I have used both the logic's as dimension.

I'm getting Below error.

Thanks..

[nareshthavidishetty]

Hi,

Please let me know how to get this.

Thanks..

[MK_QSL]

Provide sample application or sample data.

[MK9885]

num(

  sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>}Sales))

  /

  sum(TOTAL <Loc> {<Date={$(varMaxDate)},flag={'Wet Sign','eSign'},Category={'Complete','Not Complete'}>}Sales)

  ,' #,##0.0%')

???

Maybe this?

Not sure if the syntax is correct but you can check it out.