Skip to main content

Hi team,

Please find the attachment of .twbx i do have two sheet Invoice Status report and target Sheet, I have done cumulative function of Cumulative CaLculation ,

The issue i am facing is i need Invoice Id from Invoice status report  sheet and i am performing respective  calculation :

 

IF [Invoice Released Date]<DATE([Date_Selection_Para])

AND

DATEDIFF('month',[Invoice Released Date],DATE([Date_Selection_Para]-1))<1

THEN ATTR([Invoice Status Report+ (ISR)].[Invoice ID])

END

 

This calculation  giving me error, The calculation i am performing if i select any date in parameters i.e Date selection para it will give start of that month    with  Cumulative Calculation

same i am looking for invoice Id count  with is from Invoice status report  sheet .

 

 

How to handle if condition with ATTR funtion

 

 

3 answers
0/9000