Weird Error with a Let statement?

[Anonymous]

So when I use this expression in a text sheet object it works fine, I get the value that is displayed and I have confirmed it works correctly.

But I started using it a lot so i decided to make a let expression for it. When i put it in a let statement the compiler gets angry and it has the red underline and says unknown error

//Morning INV

Let MorningINV= Sum({<DDGDayStart={'$(vToday)'}>}[DDG Inventory]);

[sunny_talwar]

Problem is the $ sign.... check these links for possible solutions

Expression as a variable with $-sign expansion

Stop Dollar Sign Expansion in the script (Escape Character ??? )

[ali_hijazi]

use set instead of let

[Anonymous]

Set is for Strings not expressions.

[vishsaggi]

You can use $ sign expansion to evaluate the expression using SET. Did you try like

SET MorningINV= Sum({<DDGDayStart={'$(vToday)'}>}[DDG Inventory]);

= $(MorningINV)

[Anonymous]

This is like half a solution... Thank you, i got a number but it is an incorrect number

[sunny_talwar]

Don't want to try what is suggested in the attached links?

[Anonymous]

ive been reading them but all of the proposed solutions arent working.

[sunny_talwar]

As in they give errors or they run but not the correct number?

[vishsaggi]

Ok. Can you share some sample data or file and your expected output?