Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to use And with variable below is my expression giving wrong result.
logic: if(qtr=MaxQtr and qtr =qtr, frcst+act)
if(Quarter=vMaxQtr and Quarter=Quarter,$(vFc)+$(vAc))
how to write this in correct way?
thanks
chanty
Try this:
if(Quarter=vMaxQtr and Quarter=Quarter,'$(vFc)'+'$(vAc)')
Try this:
if(Quarter=vMaxQtr and Quarter=Quarter,'$(vFc)'+'$(vAc)')
Not working
What is Quarter = Quarter means? On a single row... Quarter will always equal to Quarter....
logic is the selection is multiple values then sum
it means maxquarter and anyother quarter
example: 2018Q3+ any quarter selected else part should take
Chanty bhai, I have no idea what you are trying to say.... do you want to may be share few rows of dummy data to show what you have and what you are looking to do with it?
i have quarter field values
2018Q3
2018Q2
2018Q1
--
---
2017Q3
so when user selected two quarters from the listbox the else part should work
Still not helpful
Hi ,
try this
sum({<Quarter={'vMaxQtr','Quarter'}>}($(vFc)+$(vAc)))