Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there, this is the part in my script that creates the set analysis part:
Let vCurrentCycle = Peek('Cycle Calendar Period',0,'Cycles');
Let vPrevMonthCycle = vCurrentCycle-1;
let vPrevYearCycle = vCurrentCycle-100;
Let vEFT_VOL_CP = '{<[Cycle Calendar Period]={$(vCurrentCycle)}>}';
Let vEFT_VOL_PP = '{<[Cycle Calendar Period]={$(vPrevYearCycle)}>}';
Let vEFT_VOL_CP = '{<[Cycle Calendar Period]={$(vPrevMonthCycle)}>}';
in my equation i'm trying this:
=sum( {$<$(vEFT_VOL_CP)>} [EFT Volume]), i have tried the following variations as well.
=sum( {$<'$(vEFT_VOL_CP)'>} [EFT Volume])
=sum( {$<{'$(vEFT_VOL_CP)'}>} [EFT Volume])
what is it i'm doing wrong.
i figured out my error, i created 2 variables with the exact same name
maybe this
=sum('$(vEFT_VOL_CP)' [EFT Volume] )
Error: Error in expression:
')' expected
Hi Stephan,
Try this,
Let vEFT_VOL_CP = '{$<[Cycle Calendar Period]={$(vCurrentCycle)}>}';
Let vEFT_VOL_PP = '{$<[Cycle Calendar Period]={$(vPrevYearCycle)}>}';
Let vEFT_VOL_CP = '{$<[Cycle Calendar Period]={$(vPrevMonthCycle)}>}';
=Sum($(vEFT_VOL_CP) [EFT Volume])
i figured out my error, i created 2 variables with the exact same name
Glad you found the mistake. I thought it was a typo. Have a nice day!!