Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a variable called vSurplus with this definition
if(ProductSpec = 'DN' or ProductSpec = 'MP' or ProductSpec = 'X' or ProductSpec = 'CL', ProductLevel-max(ProductDemand*3,ProductMinLevel) ,ProductLevel-max(ProductDemand*3,ProductOrderPt) )
So I have a column expression Surplus with this (ProductAvgCost/ProductPerUnit)* $(vSurplus) (works fine)
I am trying to set the first dimension product acording to this : if ( (ProductAvgCost/ProductPerUnit)* $(vSurplus) >0 and ProductSpec<>'O', Product )
So this way I can supress null value ...
But that does not work ... I always have nothing selected ... Maybe I am not using my variable the good way?
In that case you will need a Aggr() function as calculated dimensions with aggregation functions require you to use Aggr()
Is this the name of the field?
ProductLevel-max(ProductDemand*3,ProductMinLevel)
ProductLevel-max(ProductDemand*3,ProductOrderPt)
Or is this some kind of calculation?
A calculation ...
ProductLevel, ProductDemand , ProductMinLevel , ProductOrderPt are fields
max is a function
In that case you will need a Aggr() function as calculated dimensions with aggregation functions require you to use Aggr()
Thanks ... Reading and experimenting with aggr... will come back if I can't figure it out ...