Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
The following is the code for my variable:
=sum(if([Calendar Date]>vFYStart and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays
vNumDays doesn't change, but the [Calendar Date] changes depending on my selection in the document. How to get this variable to be regardless of selection?
=sum({1}if([Calendar Date]>vFYStart and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays
=sum({1}if([Calendar Date]>vFYStart and [Calendar Date]<vCD and [Division Abbreviation]='ATD',[FACT_SHIPMENTS_AMOUNT_TY]))/vNumDays