Solved! Go to Solution.
<<SUM(Select(Materials[Weekly Total m],AND([DATE]>=Today()-7,[DATE]<=Today())))>> ?
<<IF([Status]=โYโ,โYesโ,โNoโ)>>
This one is a bit of a guess, not knowing the table structure. But use ANY(Select(โฆ to get one response
<<ANY(Select(Materials[Weekly Total m],TRUE))>>
HI, Simon Robinson,
Thanks for your reply this information really helped me a lot.
Please help me in this.
Thanks in advance
Praveen
To make it easier for me to help, list the TableName[ColumnName] that are relevant here with their formuals and Iโll try to help further. Probably simple, but iโm stuck struggling to understand your data structure
Ok. Try taking out the <<STARTโฆ and <> statements leaving just the <<[Weekly Total m]>> in
< < END > > statements
No report is generated. mail action not triggered.
Try <<ANY(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>
Getting the value of 550 (first amount value of the selected range instead of total)
If you want a sum of all the [Weekly Total m] figures then simply change to:
<<SUM(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>
getting different value not the sum for the week
**<<SUM(Select(Materials[Weekly Total m],[DATE]>Today()-7))>>**result 65170
<<SUM(Select(Materials[Weekly Total m],[DATE] = Today() ))>> result 0
Maybe try wthe following
<<SUM(Select(Materials[Amount],[DATE] > Today() -7))>>
The expression is same as your VC [Weekly Total m].
Instead of adding up in VC and then trying to place that VC in template, you may wish to have that expression in the template itself.
Oh, our posts were almost at the same time.
Nice to know you solved it. All the best with your app.
Thanks Suvrutt_Gurjar thanks for your input
<<SUM(Select(Materials[Weekly Total m],AND([DATE]>=Today()-7,[DATE]<=Today())))>> ?
result 65170
<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this works
result 4655
thanks for opening the blockage
with love Praveen
thanks for spending your valuable time in this issue
Hey Praveen,
You are welcome. My suggestion is to please allocate the solution to yourself and @1minManager.
I just posted when you had already come up with the solution and Simon helped you with the other requirement.
<<SUM(SELECT(materials [AMOUNT], [DATE] > Today() -7))>> this WORKS
Direct sum removed the [Weekly Total m] virtual column.
Thanks
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |