Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i have a problem.
If i select Year=2017 and Quarter=Q1 i have as budget result 4253 $
If i select Yera=2017 and Quarter=Q1 and also Month=Jan,Feb,Mar the budget is 4985$
Since the Q1 is = Jan Feb Mar, i don't get why i have this difference!!!
Find attached my APP, thank you for the support!
Hello Antonio,
Try this,
Check your variable you have nullify the Quarter.
""sum({<Quarter=, Day=,Invoice_Date=,Area=,Region=,Region_Description,Product_Line=,Item_Category=>} WorkingDay)""
And Also in Budget expression:
='Budget $' & round(
if(Count(Day)=1,
((Sum({<Area-={'Area-not-available'}, Day=,Quarter=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)),
ROUND((Sum({<Area-={'Area-not-available'}, Quarter=,Day=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)*$(vWorkingDaysSelected))))
.Please find the corrected .QVW.
I could not open your qvw. Could you share the expression you are using?
='Budget $' & round(
if(Count(Day)=1,
((Sum({<Area-={'Area-not-available'}, Day=,Quarter=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)),
ROUND((Sum({<Area-={'Area-not-available'}, Quarter=,Day=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)*$(vWorkingDaysSelected))))
Hello Antonio,
Try this,
Check your variable you have nullify the Quarter.
""sum({<Quarter=, Day=,Invoice_Date=,Area=,Region=,Region_Description,Product_Line=,Item_Category=>} WorkingDay)""
And Also in Budget expression:
='Budget $' & round(
if(Count(Day)=1,
((Sum({<Area-={'Area-not-available'}, Day=,Quarter=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)),
ROUND((Sum({<Area-={'Area-not-available'}, Quarter=,Day=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)*$(vWorkingDaysSelected))))
.Please find the corrected .QVW.
And how are the variables vWorkingDays and vWorkingDaysSelected defined? And yes, please let know which value is right that you want to see in both the cases.
please close the thread by marking the correct response and any helpful responses...