Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum ({<NumFYQTR={$(=Max(NumFYQTR,1))},[Work Day in FQ]={"<=$(=VMaxPOSWDay)"},[Subscription Indicator]={$(=vProdorSub)},[Sales Type] ={"Commercial"}> }[TOTAL BOOKED ($)])
The variable is assigned by use of a button action to Non-Subscription or Subscription
But once I put in this variable instead of "Non-Subscription", it stops working.
I tried with and without the quotations adn the button is assigning the right value.
The Subscription button works for the variable, not the Non-Subscription button
is this due to the "-" in the text?
You could try:
{'$(=vProdorSub)'}
or
{'$(vProdorSub)'}
Wow you are quick and thank you, top one worked perfectly. A amzing how these tiny little changes can make or break