How to modify the below expression with out using month_n ?

[paulyeo11]

Hi All

How to modify the below expression with out using month_n ?

money(

Sum (if(Month_n=1, $(ColumnDim51)/$(Columndim89))/1000)

, $(vMoneyFormatK))

my next post i will attach my QV Doc

Paul

[avinashelite]

what is Month_n here ? a dimension? could you please elaborate more  

[paulyeo11]

Hi All

Reasons i need to remove month_n is because , my GL Table does not link with month_n

Paul

[Anonymous]

what exactly you want to achieve?

Are you getting any error with the above expression?

[paulyeo11]

Hi Avinash

if month_n=0 mean current month sales amount

if month_n=1 mean previous month sales amount

and so on.

I aware that SET analysis don't require using month_n.

Paul

[paulyeo11]

Hi Balraj

I never get any error . i cannot make use of the field name month_n , because i have sales table and GL table , as GL table does not link with month_n

Paul

[paulyeo11]

i want to achieve the same result $370K with out using month_n field in the exoression.

[sunny_talwar]

You don't want to use the if statement or you don't want to use month_n?

This seems to be working as well:

=Money(Sum({<Month_n = {1}>}$(ColumnDim51)/$(Columndim89)/1000), $(vMoneyFormatK))

[Anonymous]

I think he dont want to use Month_n  field.

Paul,

It would be better if you can share some sample data for same

[paulyeo11]

Hi sunny

I don't want to use month_n , if using month_n existing expression is working fine.

Paul

Sent from my iPhone