Expression help

[danielnevitt]

Hi,

I have the below expression that I would like to make absolute.  For example rather than netting the pos_lots, I would like the absolute sum.  Is this possible?

Sum(If(trade_dt >='$(vYesterday)',pos_lots))

Also I have the below expression and I would like to add to the expression to only show values greater than 0.10.  Is this possible as well?

Count(if (OrderStatus='Cancelled',OrderStatus))/Count(TOTAL <OriginatorUserID> OrderStatus)

Regards,

Daniel

[danielnevitt]

Hi Sunny,

Attached is some test data.

Thanks for your help with this question.

Regards,

Daniel

[sunny_talwar]

Hi Daniel, I don't see any attachment. Can you check

[danielnevitt]

Hi Sunny,

I have attached again.

Regards,

Daniel

[danielnevitt]

Hi Sunny

Were you able to see the qvw file I attached?

Regards,

Daniel

[sunny_talwar]

I have started looking at it, but have not completed. Will keep you posted if I find anything.