Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to change an expression into the variable in load script . but The expression doesnt work when I try to change it to variable
Can some one please tell me what is wrong with this script?
LET vExecutionSummaryIntakeOrder = 'sum(if([NB_Execution_Summaries_Table.sort order]={10},[NB_Execution_Summaries_Table.Order intake today]))';
LET vExecutionSummaryShmtToday = 'sum(if([NB_Execution_Summaries_Table.sort order]={10},[NB_Execution_Summaries_Table.Shmt today]))';
It looks okay. Only thing you have to be careful about is while using this variable, use with '$' symbol, i.e. call this variable like $(vExecutionSummaryIntakeOrder)
And yes, there is a catch, why are you using '{}' while comparing? Try without it like:
LET vExecutionSummaryIntakeOrder = 'sum(if([NB_Execution_Summaries_Table.sort order]=10,[NB_Execution_Summaries_Table.Order intake today]))';