Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
kaviyarasan
Contributor
Contributor

Current month data should up arrow when compare to previous month data not available in source file

Current Scenario:

Currently i'm taking month(o4) from Date (i.e 12.04.2019).but problem is i couldn't able to get month if data available in  the source.

case 1: Up Arrow

if current month > Prev Month

case 2: Down Arrow

if current month < Prev Month

Expected output:

case 3: Up Arrow

current month should show up arrow if prev month data is not available in source file

1 Reply
Channa
Specialist III
Specialist III

can you share your current expression..

try if(isnull(currentMonth),up,down)

Channa