Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community members,
I added the expression : =Sum(if('$(vStartDate)' <= '$(vEndDate)', {<TRANSACTION_DATE= {'$(vStartDate)'}>}STOCK_CONS, 0))
in a pivot table expressions, but I'm getting "-" meaning that the data is missing but I'm sure there's data.
Is there any error in the expression above?
Thank you in advance,
Abdallah
Try this
=Sum({<TRANSACTION_DATE = {'$(vStartDate)'}>} If('$(vStartDate)' <= '$(vEndDate)', STOCK_CONS, 0))
Awesome
Please close the thread by marking the correct response above.
Thanks,
Sunny
Try this
=Sum({<TRANSACTION_DATE = {'$(vStartDate)'}>} If('$(vStartDate)' <= '$(vEndDate)', STOCK_CONS, 0))
Thank you Sunny,
It's working.
Best regards,
Abdallah
Awesome
Please close the thread by marking the correct response above.
Thanks,
Sunny
Some how the "marking the correct answer" is not working right now.
I will check that later