topic Re: Daily budget calculation in App Development

Daily budget calculation

steps1989 — Sat, 16 Nov 2024 19:21:33 GMT

Hello ,

i have to table :

first table include (invoice_date ,invoice_no,store_no,store_code,invoice_AMT )

second table is an excel sheet which is including ( store_no,daily budget date ,daily budget )

in case of selecting invoice date it should read directly the daily budget for the same store_no )

so any suggestion please .

thanks

Re: Daily budget calculation

lorenzoconforti — Sat, 04 Jan 2020 23:42:37 GMT

If I understood correctly what you are trying to achieve, you can do it by using this expression:

Sum({<DAILY_BUDGET_DATE = p(INVOICE_DATE)>}BUDGET)

See attached example dashboard

Re: Daily budget calculation

Kushal_Chawda — Sun, 05 Jan 2020 11:35:52 GMT

Why don't you just link both the table on below key

table1: load invoice_date , invoice_no, store_no, autonumber#256(store_no&invoice_date) as Key store_code, invoice_AMT FROM table1; table2: store_no, , load [daily budget date] , store_no, autonumber#256(store_no&[daily budget date]) as Key [daily budget] FROM table1;

If you link the table this way it will automatically give you budget value when you select any invoice date. Before that please check the grain of both table on this Key and then accordingly do the change