Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i am using this in script. but one variable is not working its showing when i add in text object expression garbage
Add single quotes or double quotes
=sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)
=sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)
Would you be able to show an image of these three variable in variable overview
Hi sunny,
second variable we are not using anywhere so no issue with that.
remaining two screen shots. in dashboard quarter is selected 2019Q2 on open.(Max quarter)
i n text object added variable the below error is coming.
Just try to use =vPrevYrQtr in the text box object instead of =$(vPrevYrQtr)
the result is 111180.45 but when use that variable in expression its giving me 0
Change the expression to this
=sum({$<Year,Half_Year,Quarter={$(=vPrevYrQtr)},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={$(=vPrevYrQtr)},Type={'SR'}>}SA)
getting error
Add single quotes or double quotes
=sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={'$(=vPrevYrQtr)'},Type={'SR'}>}SA)
=sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)
+sum({$<Year,Half_Year,Quarter={"$(=vPrevYrQtr)"},Type={'SR'}>}SA)