Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can some body advice me can we use Aggr function on another expression value within straight table by different dimension.
Here it my usecase.
My Input:
My Expected Straight table O/P :
Here i am trying to aggregate Column(Amt) value by Product, Quarter and expected value is same as "AGGR at Quarter" expression.
but instead of Aggr(Sum(AMt),Product,Quarter) i used Aggr(Sum(Column(1)),Product,Quarter).
Can you some body let us know is it possible to reference column name in Aggr function?
Attached sample App.
Thanks you all.
I am able to achieve with below expression.
If( QuarterStart(MakeDate(Year,Month)) = MakeDate(Year,Month),RangeSum(Below(Column(27),0,3)), Above(Column(30)))
Basically i am checking Quarter Start and if it matches then using RangeSum function with below function to aggregate forward 3 records amount.
Thanks,
hi
to the best of my knowledge you can't
use column function inside aggr ,
and generally you can't use an expression result in one table in another table
Sample app is not attached
Hi Kush,
Attached sample app.
Use Sum(total <Product,Quarter>AMt)
This is what you are looking for? See the attached
Hi Kush,
Thanks for looking
In Mycase i wanted to use Column(1) or Expression Name instead of Actual field "AMt" because in real scenario Amt is derived value.
So you can do that calculation in script using If else and then use that Amout
How amount is derived ?
Thanks you all.
I am able to achieve with below expression.
If( QuarterStart(MakeDate(Year,Month)) = MakeDate(Year,Month),RangeSum(Below(Column(27),0,3)), Above(Column(30)))
Basically i am checking Quarter Start and if it matches then using RangeSum function with below function to aggregate forward 3 records amount.
Thanks,