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]);

[Anonymous]

They either give a blank text object or an expression error is displayed on the text object.

[sunny_talwar]

Try this

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

[MK9885]

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

Maybe use ' ' ??

Whats the use of creating a variable in script when you can do it in front end, easier to modify too

[sunny_talwar · Accepted solution]

Give this a short

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

[Anonymous]

This worked!! Thank you!

[sunny_talwar]

Used the same logic from what was given by Stefan here

Expression as a variable with $-sign expansion