Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SET vMonth2019 = 2019
SET vStatus = IF($(vMonth2019 )='0','N','Y');
SUM({$<[Contion1]={'True'}, vStatus ={'Y'}"}>}$(vTotal))) // Need to use vStatus Variable inside expression.
Thanks in Advance !
SET vStatus = IF($(vMonth2019 )='0','N','Y');
SUM({$<[Contion1]={'True'}, vStatus={'$(vStatus)'}}>}$(vTotal)))
//Tried as you said, but its giving all the value vMonth2019 as 0.
Any other solution?
SUM({$<[Contion1]={'True'}, vStatus ={'Y'}"}>}$(vTotal))) which i have highlighted in RED that should be field.
You can write in script.
IF(Year=0, 'N', 'Y') as Field; or IF(Len(Year)=0, 'N', 'Y') as Field ; or IF(Len(Trim(Year))=0, 'N', 'Y') as Field ;
If you provide sample data that would be great, easy to understand.