Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I try without succes to insert into an expression data calculated from another expression:
Here is my initial expression that is working fine:
Sum( {$<DATATRAN.autoCalendar.Date = {">=$(=Min(Date( today(0) - 40 ,'MM/DD/YYYY')))<=$(=Max(today(0)))"},[NRSHOP]={5} >} [VANZARI_OPERATIONALE.CANTITATE])
I am trying to change the fix number marked with red from above with a dynamically calculated number that is stored in another column: Column(3), so the expression should be:
This version of the above expression doesnt work:
Sum( {$<DATATRAN.autoCalendar.Date = {">=$(=Min(Date( today(0) - Column(3),'MM/DD/YYYY')))<=$(=Max(today(0)))"},[NRSHOP]={5} >} [VANZARI_OPERATIONALE.CANTITATE])
Column 3 has this expression that calculate the number, that is different for each record so this is why I cant use a fixed number:
Num(today(0) - FirstSortedValue({$<[RECEPTII.NRSHOP]={5}>}[RECEPTII.DATANIR], -[RECEPTII.DATANIR]))
Any idee how to make this work?
store u expression of column2 into a variable then call ur varibale instead of the column
-$(vUrColumn2Variable)
I think set analysis is not appropriate for this issue, becouse it doesn't calculate for each row. Try to use If() statement instead.
Andrey is correct. Set expressions are evaluated before the chart detail is created, and Column(3) has no value at that time. A sum(if()) may work for you if the data set is not too large. Otherwise, you will have to rethink your logic.