Variable issue

risabhroy_03 — Fri, 21 Jan 2022 05:38:08 GMT

I am using the below variable in my measure and it works perfectly correct.

let vLastmonthdate2 =floor(num(Date(floor(monthend(addmonths(Today(),-1))))));

My measure is Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={"$(vLastmonthdate2)"}>} Weight_Inventory)

But when I just put the value in place of variable, it is giving me wrong values

Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={'=$(=(floor(num(Date(floor(monthend(addmonths(Today(),-1))))))))'}>}Weight_Inventory)

Can anyone please help me?

Re: Variable issue

marcus_sommer — Fri, 21 Jan 2022 07:45:16 GMT

Try it with:

let vLastmonthdate2 =floor(monthend(addmonths(Today(),-1)));

Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={"$(=floor(monthend(addmonths(Today(),-1))))"}>}Weight_Inventory)

- Marcus

topic Re: Variable issue in App Development

Variable issue

Re: Variable issue