set analysis Expression

[absekrafi]

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

[sunny_talwar · Accepted solution]

Try this

=Sum({<TRANSACTION_DATE = {'$(vStartDate)'}>} If('$(vStartDate)' <= '$(vEndDate)', STOCK_CONS, 0))

[absekrafi · Accepted solution]

Thank you Sunny,

It's working.

Best regards,

Abdallah

[sunny_talwar · Accepted solution]

Awesome

Please close the thread by marking the correct response above.

Thanks,

Sunny

[absekrafi]

Some how the "marking the correct answer" is not working right now.

I will check that later